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!

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!

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!

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!

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!

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!

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!

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!

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!

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!

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!