| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if, then, if not
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if, then, if not
Try this:
=IF(ISNUMBER(F3),IF(F3=0,1,L3/F3),"") Biff "Tammy" wrote in message ... 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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if, then, if not
I have to clarify something. L3 might contain a negative #. and I don't
want any results to show negative. "T. Valko" wrote: Try this: =IF(ISNUMBER(F3),IF(F3=0,1,L3/F3),"") Biff "Tammy" wrote in message ... 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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if, then, if not
Ok......
=IF(ISNUMBER(F3),IF(F3=0,1,ABS(L3/F3)),"") Biff "Tammy" wrote in message ... I have to clarify something. L3 might contain a negative #. and I don't want any results to show negative. "T. Valko" wrote: Try this: =IF(ISNUMBER(F3),IF(F3=0,1,L3/F3),"") Biff "Tammy" wrote in message ... 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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if, then, if not
=IF(F3=0,1,L3/F3)
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Tammy" wrote in message ... 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! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if, then, if not
=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 -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Tammy" wrote in message ... 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! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if, then, if not
=IF(F3=0,1,L3/F3)
-- Gary''s Student gsnu200707 "Tammy" wrote: 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! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if, then, if not
thank you Garys Student - how do I get the result to not be a negative number?
"Gary''s Student" wrote: =IF(F3=0,1,L3/F3) -- Gary''s Student gsnu200707 "Tammy" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
