Hiding #VALUE!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Digital2k - 16 Jul 2006 20:37 GMT

I have a column with formulas, and when there is no data to calculate I get
a #VALUE! I would like to hide #VALUE!
Can anyone point me in the right direction?
Thanks
Digital2k

Reply to this Message

Chip Pearson - 16 Jul 2006 20:42 GMT

You might try writing your formulas like

=IF(ISERROR(your_formula),"",your_formula)

The disadvantage of such an approach it that your_formula will
often be calculated twice, resulting in a performance hit.

Signature

Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

>I have a column with formulas, and when there is no data to
>calculate I get a #VALUE! I would like to hide #VALUE!
> Can anyone point me in the right direction?
> Thanks
> Digital2k

Reply to this Message

Dave Peterson - 16 Jul 2006 20:43 GMT

You have a couple of options...

=if(iserror(yourformula),"",yourformula)

You may be able to just use the portion of the formula that causes the error.

Another option is to use Format|conditonal formatting to hide the error (white
font on white fill???).

> I have a column with formulas, and when there is no data to calculate I get
> a #VALUE! I would like to hide #VALUE!
> Can anyone point me in the right direction?
> Thanks
> Digital2k

Signature

Dave Peterson

Reply to this Message

daddylonglegs - 16 Jul 2006 21:01 GMT

If your formula is referencing only one cell, e.g. A1 then use

=IF(A1="","",your_formula)

There may be a simpler way, waht's the formula?

Signature

daddylonglegs

Reply to this Message

Digital2k - 17 Jul 2006 00:47 GMT

Thank you all, I used the conditional format to solve the problem.
Digital2k

> If your formula is referencing only one cell, e.g. A1 then use
>
> =IF(A1="","",your_formula)
>
> There may be a simpler way, waht's the formula?

Reply to this Message

Rate this thread: