#N/A values

Hai, like we opt to hide zero values, is there any way to hide #N/A (as a
result of a funtion or formula) values in an excel sheet?

Trivikram.

FARAZQURESHI
Wed Jul 23 01:49:00 CDT 2008

Simply try:

=if(ISNA([YOUR FORMULA]),"",[YOUR FORMULA])

Insert your formula in place of [YOUR FORMULA]

--

Best Regards,
FARAZ A. QURESHI


"Trivikram" wrote:

> Hai, like we opt to hide zero values, is there any way to hide #N/A (as a
> result of a funtion or formula) values in an excel sheet?
>
> Trivikram.

David
Wed Jul 23 02:22:31 CDT 2008

You can use conditional formatting to make the font white (or whatever the
background colour of the cell is).
--
David Biddulph

"Trivikram" <vichram at the rate of yahoo dot com> wrote in message
news:38907477-C4A6-4183-9789-E1E703213FCD@microsoft.com...
> Hai, like we opt to hide zero values, is there any way to hide #N/A (as a
> result of a funtion or formula) values in an excel sheet?
>
> Trivikram.

ramzi
Wed Jul 23 04:09:01 CDT 2008

HI Faraz,

if have problem with ur formula... I doing like below..

=if(ISNA(=A1),"",=B1)

and

=IF(F9=0,"","=H4")

if have problem with =H4 (the formula)

thanks in advance





"FARAZ QURESHI" wrote:

> Simply try:
>
> =if(ISNA([YOUR FORMULA]),"",[YOUR FORMULA])
>
> Insert your formula in place of [YOUR FORMULA]
>
> --
>
> Best Regards,
> FARAZ A. QURESHI
>
>
> "Trivikram" wrote:
>
> > Hai, like we opt to hide zero values, is there any way to hide #N/A (as a
> > result of a funtion or formula) values in an excel sheet?
> >
> > Trivikram.

Rick
Wed Jul 23 04:32:05 CDT 2008

You can alternatively use ISERROR instead of ISNA.

"FARAZ QURESHI" wrote:

> Simply try:
>
> =if(ISNA([YOUR FORMULA]),"",[YOUR FORMULA])
>
> Insert your formula in place of [YOUR FORMULA]
>
> --
>
> Best Regards,
> FARAZ A. QURESHI
>
>
> "Trivikram" wrote:
>
> > Hai, like we opt to hide zero values, is there any way to hide #N/A (as a
> > result of a funtion or formula) values in an excel sheet?
> >
> > Trivikram.

Gord
Wed Jul 23 14:46:22 CDT 2008

Which will mask any error, not just the #N/A

Might not be desirable.


Gord Dibben MS Excel MVP

On Wed, 23 Jul 2008 02:32:05 -0700, Rick <Rick@discussions.microsoft.com>
wrote:

>You can alternatively use ISERROR instead of ISNA.
>
>"FARAZ QURESHI" wrote:
>
>> Simply try:
>>
>> =if(ISNA([YOUR FORMULA]),"",[YOUR FORMULA])
>>
>> Insert your formula in place of [YOUR FORMULA]
>>
>> --
>>
>> Best Regards,
>> FARAZ A. QURESHI
>>
>>
>> "Trivikram" wrote:
>>
>> > Hai, like we opt to hide zero values, is there any way to hide #N/A (as a
>> > result of a funtion or formula) values in an excel sheet?
>> >
>> > Trivikram.