ST Alpha - "try: =IF(J22="Paid",I23-F22,"NO")" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 152

In response to "I tried this." by Mel Profit

try: =IF(J22="Paid",I23-F22,"NO")

Posted by prayformojo (aka mayhem) Apr 22 '15, 18:40

you need quote marks around
NO
and there should be an equal sign after J22, no a minus sign

Responses:

This worked. Now - let's go for the Gold Star... - Mel Profit Apr 22, 18:56 17
- 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
This. -- nm - iSpam Apr 22, 18:48
This. Can J22 ever be empty or blank? Or is it always Paid or Submitted? -- nm - JaxSean Apr 22, 18:45 1
- Never blank - always "Paid" or "Submitted". -- nm - Mel Profit Apr 22, 18:49

Post a message top

try: =IF(J22="Paid",I23-F22,"NO")

Replies are disabled on threads older than 7 days.