Dave, you are also right on, thanks...

"Dave F" wrote:

It's not returning a formula. It's just returning a string of text that
looks like your formula. Notice that you have double quotation marks around
the formula. Eliminate those:

=IF((C35*0.85-F35-G35+I35)<=0,"0",(C35*0.85-F35-G35+I35))

It's also not clear what you intend your calculation to be here. Do you
mean for C35*.85 to be calculated and then from that product, subtract F35,
G35 and add I35? For auditing purposes in the future, if that's the math you
intend you may want to re-write the formula like this:

=IF((C35*0.85)-F35-G35+I35)<=0,"0",((C35*0.85)-F35-G35+I35))

Dave

--
Brevity is the soul of wit.


"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