if, then, if not

T

Tammy

Hello Smart people!

I need help with the following formula PLEASE!

I'll just write this as best I can - For Column "O"

If F3="0" (zero), then then result should be "1" but if F3 is anything but
"0" (zero) - I want to divide L3/F3.

Any help appreciated as always!
 
B

Bob Phillips

=IF(F3=0,1,L3/F3)


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
B

Bernard Liengme

=IF(F3=0,1,L3/F3)
The syntax is
=IF( what-to-test, what-to-do-if-test-is-true, what-to-do-otherwise)
best wishes
 
T

Tammy

I have to clarify something. L3 might contain a negative #. and I don't
want any results to show negative.
 
T

Tammy

OMG - he keeps adding more criteria for the formula! I'm gonna scream.

THe last and final piece of the puzzle is and I can't have negatives in the
results.

and btw - the =ABS(If(F3=0,1,L3/F3)) worked perfectly.

Ok -
If L3 = "0" zero, then the result should be "1", If not L3/F3

Thanks in advance!
 
D

David Biddulph

I would suggest that you look at Excel's help to understand the functions
and the syntax. There are examples in help to explain it.

How about
=IF(OR(F3=0,L3=0),1,ABS(L3/F3)) ?
 
Top