-Macros$$ Re: how to hide #N/A
Hi Harris,
One could also write the formula to be;
=if(isna(A1),0,A1)
A1 is the reference of your Formula, so it could be anything from a
sum to a lookup and so on.
Thanks
Andre
On Aug 6, 8:31 am, harris a wrote:
> Hello,
>
> In case a formula is return
Hi Harris,
One could also write the formula to be;
=if(isna(A1),0,A1)
A1 is the reference of your Formula, so it could be anything from a
sum to a lookup and so on.
Thanks
Andre
On Aug 6, 8:31 am, harris a wrote:
> Hello,
>
> In case a formula is returning “#N/A” then is there a way by which
Hi Harris,
You would need to nest the ISERROR function in your formula.
For example:
=IF(ISERROR(your formula)=TRUE,"",your formula)
Regards.
> Date: Wed, 5 Aug 2009 23:31:30 -0700
> Subject: $$Excel-Macros$$ how to hide #N/A
> From: harris...@gmail.com
> To: excel-macros@g
Dear Harris ,
it may be done through conditional formating .
Change the font colour to background colour. then put the condition if the
result comes out
as other than N/A then font colour would be changed as black.
Hope it would solve your problem.
On 8/6/09, harris a wrote:
>
>
> Hello
Hi Harris,
Two ways:-
1). You can use error handler with the help of functions
eg. =if(iserror(match(a1,b:c,0)),"",match(a1,b:c,0))
2). You can apply conditional formatting to hide the errors. Enter
following formula in conditional formatting window:-
=iserror(reference)
and choose font color as