ST Alpha - "Getting even more fancy..." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 152

In response to "You have quotes around no?" by iSpam

Getting even more fancy...

Posted by Mel Profit (aka mel profit) Apr 22 '15, 19:05

say I have 3 statuses (I do..."Paid", "In-Process" and "Submitted"). Can I get In-Process and Submitted to result in different No Statements. Instead of "No" can one say "X" while the other says, "Y".

Responses:

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

Post a message top

Getting even more fancy...

Replies are disabled on threads older than 7 days.