ST Alpha - "Not in Excel. You could do a nested if, though." (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 154

In response to "I'm being lazy -- can I do join two if statements with "and"? like "if a2 is less than 10" AND "if column c =blue", do this? is this poss?" by the amanda nones

Not in Excel. You could do a nested if, though.

Posted by spamlet Jan 27 '12, 10:57

(If a2 is less than 10, (if column c = blue, both true, second false), first false)

Responses:

here's one guide -- (link) - Beryllium Jan 27, 10:58 1
- That's a more elegant way. Mine is just an a second if statement in the "true" of the first if statement. -- nm - spamlet Jan 27, 10:59

Post a message top

Replies are disabled on threads older than 7 days.