"That doesn't work" wins the prize for the most unhelpful post of the day.

If you had wanted further help, you would have told us what values you had
as your inputs, what result you got from the formula, and what result you
expected, but as you did not give any of that information we can't tell you
what you did wrong.
[Kevin's formula was correct, of course, so if that isn't the right answer
it means you asked the wrong question.]
--
David Biddulph

"Nigel" wrote in message
...
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