View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Colin Hayes Colin Hayes is offline
external usenet poster
 
Posts: 465
Default Satisfying several criteria



Hi All

I'm trying to write a formula to satisfy this criteria :

If A1+B1 0 then put A1+B1 , otherwise leave blank.

BUT if C1 has content , put "0.00".


Can someone help with a formula to include these parameters?

Grateful for any help.