=IF(C1<"",0,IF(A1+B10,A1+B1,""))


Gord Dibben Microsoft Excel MVP


On Sat, 10 Sep 2011 14:57:11 +0100, Colin Hayes
wrote:



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.