If your formula is =A1/B1, try =IF(B1="","",A1/B1) or
=IF(OR(A1="",B1=""),"",A1/B1)
--
David Biddulph

"Pete_UK" wrote in message
oups.com...
Post your formula, then we can comment on it directly.

Pete

On Nov 8, 10:30 pm, Excel Noob <Excel
wrote:
I have plotted out a worksheet, but the problem is that it is trying to
calculate empty cells as having a value of zero. This means that
whenever it
is a divide function, it shows up as an error. I need it to count empty
cells as having no value, or to just ignore them, so that it does not
affect
related formulas. Any help?