Hello,

I have in some cells some formulas that look for a value in other cells
and then do their calculations.
But when these cells, that are looked at, don't have a value in them
the other cells, waiting to calculate, end up with either a FALSE, ###,
or #VALUE! in the cell.

I would like to have these be blank when nothing is to be calculated.

Am I missing something in the formula to make these cells blank?

Thanks a lot,

Alan


--
AnimatorElf
------------------------------------------------------------------------
AnimatorElf's Profile: http://www.excelforum.com/member.php...o&userid=32944
View this thread: http://www.excelforum.com/showthread...hreadid=527813