"If" formula help
Rob, try this, =IF((C35*0.85-F35-G35+I35)<=0,0,(C35*0.85-F35-G35+I35))
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"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...
Rob
|