Hi All,

Can someone please help me.

Im doing a very simple formula

=D5-C5
=D6-C6
=D7-C7 etc etc etc

But on the cells in column c or d occasionally it will be blank or "0".

Everytime one of these cells is blank or zero i get the response #VALUE

Is there a formula I can use so that instead of getting the error message