Unless you formulated your intitial question incorrectly, it works just fine.
Dave Biddulph has given the same formula along with an "If you have to nest"
IF formula.


--
Kevin Backmann


"Nigel" wrote:

No that doesn't work

"Kevin B" wrote:

Try this:

=IF(OR(C4=0,D4=0),0,C4-D4)

Hope this helps.
--
Kevin Backmann


"Nigel" wrote:

Thius is a stupid question but I cannot for the life of me work it out

the calculation I need is

if C4=0 or if D4 = 0 then 0 else c4-d4