Mulitple "IF/OR" statments

M

Mutiple IF/OR

I need a formula which will test 2 cells for "<0" and perform the same
funtion if either cell is less than zero. If either cell is more than zero
perform a different function.

IF (F4 OR K3) = less than zero then current cell = zero
IF (F4 OR K3) is greater than zero then = (F4-H4)*.46
 
D

Don Guillett

Merry Christmas from Texas but you could have looked in the help index for
OR and IF.
=IF(OR(F4>0,K3>0),(F4-H4)*46,0)
or is this what you want
=IF(OR(AND(K3>0,F4>0),AND(K3>0,F4>0)),(F4-H4)*46,0)
 
D

David Biddulph

=IF(OR(F4<0,K3<0),0,IF(OR(F4>0,K3>0),(F4-H4)*0.46,"Both F4 and K3 are equal
to zero"))
but I doubt whether that's what you really wanted.
 
J

joeu2004

I need a formula which will test 2 cells for "<0" and perform the same
funtion if either cell is less than zero. If either cell is more than zero
perform a different function.

IF (F4 OR K3) = less than zero then current cell = zero
IF (F4 OR K3) is greater than zero then = (F4-H4)*.46
Click to expand...

First, your conditions are not mutually exclusive, unless your are
implying an ordered test. What do you expect if F4 is less than zero
and K3 is greater than zero?

Second, you have not covered all cases. What do you expect if both F4
and K3 equal zero?

(Hint: The opposite of "less than" is "greater than or equal to", not
simply "greater than".)
 
Top