Thread: If/Or statement
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default 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.