If/Or statement
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.
--
David Biddulph
"Janet" wrote in message
...
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.
|