Thread
:
Hiding #N/A error (or displaying a blank cell instead of #N/A)
View Single Post
#
2
Posted to microsoft.public.excel.newusers
Niek Otten
external usenet poster
Posts: 3,440
Hiding #N/A error (or displaying a blank cell instead of #N/A)
=IF(ISNA(YourFormula),"",YourFormula)
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Eva Marie" <Eva
wrote in message ...
| Hello,
|
| I have a formula which is working correctly; however when it doesn't locate
| the data (as will happens sometimes), it displays the #N/A error. I would
| prefer it display a blank cell. Can someone please tell me how to do this in
| Excel?
|
| Formula: =IF(P28=0,"",INDEX('Ext''d
| Lines'!$B$1:$CD$1,MATCH(P28,INDEX('Ext''d
| Lines'!$B$2:$CD$230,MATCH($A28,'Ext''d Lines'!$A$2:$A$230,0),0),1)+1))
|
| Thanks,
| Eva Marie
Reply With Quote
Niek Otten
View Public Profile
Find all posts by Niek Otten