Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How to display blank cell instead of #value

I'm entering the following formula into cell D6:

=IF(C16>=-5,C16+10,null)

This is resulting in #value, as C16 is blank.

Cell C16 currently has a formula in it. Is this what is causing the problem and is there no way around it until there is a value in C16, or is there some way to have D6 show blank until both formulas have a value?

How to display blank cell instead of #value

I'm entering the following formula into cell D6:

=IF(C16>=-5,C16+10,null)

This is resulting in #value, as C16 is blank.

Cell C16 currently has a formula in it. Is this what is causing the problem and is there no way around it until there is a value in C16, or is there some way to have D6 show blank until both formulas have a value?