If/Or statement

J

Janet

I have got most of the statement, it is just not putting the correct True
Value in. What I have is =IF(OR(B3=1,2,3,201,202),C3,""). If B3 has any other
number, I want to leave the blank. What it is doing is putting in the value
of C3. Any help would be greatly appreciated.
 
D

David Biddulph

2 is TRUE, 3 is TRUE, 201 is TRUE, 202 is TRUE (and similarly any non-zero
number is TRUE).
You have used those as arguments for your OR function, so of course the
answer of the OR is TRUE (regardless of whether or not B3=1), hence the IF
returns C3.
 
Top