ST Alpha - "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?" (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

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?

Posted by the amanda nones (aka amanda) Jan 27 '12, 10:53

or do I have to use index matching?

Responses:

oops - sorry - this is a tech question huh? I was going to post - you're Amanda - you can do anything you want! - JenBro Jan 27, 11:02
you can do it in excel. =IF ( AND (a2 < 10, c1 = "blue"), TRUE, FALSE) -- nm - decline Jan 27, 11:00
Not in Excel. You could do a nested if, though. - spamlet Jan 27, 10:57 2
- 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
Logically it's possible, the actual grammar of it will depend on what you're doing it in. -- nm - Ender Jan 27, 10:57 1
- this. - Beryllium Jan 27, 10:58
I can't see why not. nm -- nm - groiny Jan 27, 10:56
you can do anything - encyclopedia pixie Jan 27, 10:55 1
- ... at ZOMBOCOM. This *is* ZOMBOCOM. -- nm - Beryllium Jan 27, 10:57

Post a message top

Replies are disabled on threads older than 7 days.