View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Tammy Tammy is offline
external usenet poster
 
Posts: 145
Default 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!