If you're getting that #Value! error, that means that at least one of the two
cells (maybe both) really aren't empty.

It could contain a space character or any whitespace character.

Or it could contain a formula that evaluates to ""
like
=if(x1="ok","","Error")

Or it could have been a formula that evaluated to "" and then was converted to
values. (That cell won't be empty, but will look blank.)

I'd just select the range (a1 and/or b1) and hit the delete key to clear the
contents.

Then the cell(s) will really be empty.



Dannn78 wrote:

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

--

Dave Peterson