ST Alpha - "This worked. Now - let's go for the Gold Star..." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 152

In response to "try: =IF(J22="Paid",I23-F22,"NO")" by prayformojo

This worked. Now - let's go for the Gold Star...

Posted by Mel Profit (aka mel profit) Apr 22 '15, 18:56

It works for Paid. How do I get it to say something other than, "#Name? if it's marked as Submitted. I thought the "NO" would cover that but apparently not.

Still, this is excellent. Thank you all.

Responses:

If the column is formatted for values, you'll need a value representation I think -- nm - budice Apr 22, 19:01
You have quotes around no? - iSpam Apr 22, 18:58 13
- Getting even more fancy... - Mel Profit Apr 22, 19:05 8
  - nested if, yes. if(a1="paid", "blah", if(a1="in process", "blah 2", if(a1="submitted", "blah 3"))) -- nm - all the boys love OBBR Apr 22, 19:12 6
    - Got it. It worked. Mel Points for you. -- nm - Mel Profit Apr 22, 19:17
    - watch your parentheses. I suck at nested ifs because I always miscount parentheses. also a max of seven ifs is allowed per statement. -- nm - all the boys love OBBR Apr 22, 19:13 4
      - This. It's actually how I learned the step through trick because I always eff up nested statements. -- nm - spamlet Apr 22, 19:20 2
        
        "step through trick"? what? (I suck so bad at nested if. I always embarrass myself.) -- nm - all the boys love OBBR Apr 22, 19:44
        
        I have another question for you folks but I think my brain is fried and I actually need to use the sheet for it's ultimate purpose. -- nm - Mel Profit Apr 22, 19:42
      - SQL helped train me for this, -- nm - Mel Profit Apr 22, 19:17
  - in other words can I have multiple Value if False statements? -- nm - Mel Profit Apr 22, 19:06
- *bugs bunny make-out kiss* thanks...that's the final trick. It all worked. -- nm - Mel Profit Apr 22, 19:01
- Another trick you can do is put the cursor between the f and the open parenthesis and hit the "fx" button next to where you type stuff. It will walk - iSpam Apr 22, 19:00 2
  - oh this. I try so hard not to use this. -- nm - all the boys love OBBR Apr 22, 19:45
  - thanks, -- nm - Mel Profit Apr 22, 19:01
you have to put the "NO" in quotes - znufrii Apr 22, 18:58 1
- and nevermind my lack of reading comprehesion - znufrii Apr 22, 18:59

Post a message top

This worked. Now - let's go for the Gold Star...

Replies are disabled on threads older than 7 days.