ST Alpha - "You have quotes around no?" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 152

In response to "This worked. Now - let's go for the Gold Star..." by Mel Profit

You have quotes around no?

Posted by iSpam (aka spamlet) Apr 22 '15, 18:58

That should work.

Is the cell formatted as a number? It shouldn't matter but change it to text.

Responses:

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

Post a message top

You have quotes around no?

Replies are disabled on threads older than 7 days.