Hi everyone,

In columns A and B on my worksheet I input numbers from a printout.

If there are any 0 values on the printout for the data to be entered in
either column A or B, then the cell should be left empty rather than the 0
input.

In column C I had a formula that divides the value in column A by the value
in column B e.g. =A1/B1.

For the rows with blank cells, the formula in column C returned either 0 or
#DIV/0! where I wanted it to be blank.

To get around this problem I changed the formula in column C e.g:

=IF(OR(ISBLANK(A1),ISBLANK(B1)),"",A1/B1)

This works fine as far as it goes, however, In column D I have the formula
=C1+5

For the rows with "blank" values in columns A or B the formula in column D
returns #VALUE obviously because I'm trying to add a number to a text value,
albeit a blank one.

This is a problem I come across repeatedly, please can anybody suggest away
that I can get the IF function to return a truly blank value rather than
just an empty text string?

Thanks in advance,

Steve