View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rob Rob is offline
external usenet poster
 
Posts: 718
Default "If" formula help

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