IF formula
Thanks for the reminder.
David Biddulph wrote:
Not really necessary to use OR.
You can change =IF(OR(A2150,A2=150),5,0) to =IF(A2=150,5,0)
--
David Biddulph
"Bob I" wrote in message
...
A2 contains "x"
=IF(OR(A2150,A2=150),5,0)
Peekaboo012885 wrote:
I'm trying to enter an IF formula but can't seem to get it written
correctly...what I want to do is " IF x is or = $150 then the value is
5, if less than 150 then value is 0."
|