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.