| 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
=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! |
|
#4
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if, then, if not
=ABS(IF(F3=0,1,L3/F3))
-- Gary''s Student gsnu200707 "Tammy" wrote: 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! |
|
#6
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! |
|
#7
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! |
|
#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! |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if, then, if not
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! "Gary''s Student" wrote: =ABS(IF(F3=0,1,L3/F3)) -- Gary''s Student gsnu200707 "Tammy" wrote: 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! |
|
#10
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! |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if, then, if not
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)) ? -- David Biddulph "Tammy" wrote in message ... 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! "Gary''s Student" wrote: =ABS(IF(F3=0,1,L3/F3)) -- Gary''s Student gsnu200707 "Tammy" wrote: 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 | |
|
|
Linear Mode
