Mulitple "IF/OR" statments
 

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

Mulitple "IF/OR" statments
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mutiple IF/OR" <Mutiple wrote in message
...
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

Mulitple "IF/OR" statments
 

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

"Mutiple IF/OR" <Mutiple wrote in message
...
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

Mulitple "IF/OR" statments
 

On Dec 25, 5:49*am, Mutiple IF/OR <Mutiple
wrote:
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

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".)