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.