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