making cells blank that arent ready to be calculated

R

RalphSE

hi,

i have some spreadhseets where the formulas are calculating data that
isnt ready yet, i.e. the formulas are copied down in advance but are
for monthly balances in the future, so some of them say "#DIV/O!" and
others say "-100%", is there any way to have excel just make these
cells be blank until they are actually being calculated but retain the
formulas??

i hope i made my question clear...

thanks
 
P

Pete_UK

Hi Ralph,

If your formula is something like =A1/B1, you could change this to:

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

This will give you a blank if either A1 or B1 (or both) are empty or 0.

Hope this helps.

Pete
 
Top