"If" formula help
"David Biddulph" wrote in message
...
"Rob" wrote in message
...
Here is the formula I am using...
=IF((C35*0.85-F35-G35+I35)<=0,"0","(C35*0.85-F35-G35+I35)")
So, If the answer the the first formula (C35*0.85-F35-G35+I35) is <=0,
then
it should return 0. THis part works.
If the answer to the first formula (C35*0.85-F35-G35+I35) is not <=0,
then I
want it to return the answer to the forumla C35*0.85-F35-G35+I35. It is
simply returning the formula, not the answer.
What am I going wrong. I have tried all kinds of things, and can't get
it
to work...
The quote marks tell it to return a text string, so that's what you got
(both a text string of zero, and a text string for the formula).
Try
=IF((C35*0.85-F35-G35+I35)<=0,0,C35*0.85-F35-G35+I35)
.... but a simpler option is
=MAX(C35*0.85-F35-G35+I35,0)
--
David Biddulph
|