ST Alpha - "I tried this." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 152

I tried this.

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

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

and got #Value!

J22 is where my drop down of Paid or Submitted is. I23 is where my invoice total is. F22 is where my PO Grand Total is. This equation is where I want Remaining PO total to go *IF* the Invoice is Paid.

Responses:

What's the Name given to the Drop Down list? -- nm - budice Apr 22, 18:53 1
- Invoice Status. -- nm - Mel Profit Apr 22, 19:03
Listen to mojo. You're statement doesn't have anything to test in the first bit so it can't do anything. - iSpam Apr 22, 18:49
try: =IF(J22="Paid",I23-F22,"NO") - prayformojo Apr 22, 18:40 21
- 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

I tried this.

Replies are disabled on threads older than 7 days.