A formula cannot return a true blank - the cell contains the formula,
after all !

As Kevin says, change your dependent formulae to:

=IF(cell="","",your_calculations)

to avoid the errors.

Hope this helps.

Pete

On Aug 28, 9:46 pm, D wrote:
I need an if statment to return a true blank. I currently have
=IF(C129<0,C129*-1,"") as a formula, when fales it returns an empty cell
that returns #value when used in calcuations. I do not want it to return a
zero value, nor can I turn on the option to leave a cell blank for a
calculated zero value, due to other calculations that I need to return zero.

Thanks is advance