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
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.