An easier solution =max(0,C35*0.85-F35-G35+I35). If the calculated number is
less than zero - your answer will be zero - else it will be calculated answer

"Rob" wrote:

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