ST Alpha - "After trial and error, I found that =IF(OR(B1="up006",AND((B1="up260"),(C1>12))),1,0) works" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 154

In response to "=IF(OR(B1=UP006, AND(B1=UP260, C>12)),1, 0) -- nm" by znufrii

After trial and error, I found that =IF(OR(B1="up006",AND((B1="up260"),(C1>12))),1,0) works

Posted by JD (aka Jason Dean) Sep 17 '12, 13:54

Assuming that UP006 and UP260 are literal entries.

Znu's seems to be short one set of parenthesis around the conditions for the AND

Post a message top