You could start by posting the formula(s)

=IF(looked_at_cell="","",your_formula)

would take care of empty cell

If you get false you have either an if function without anything in the (if
false do what)
or a condition like =A22


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"AnimatorElf"
wrote in message
...

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