ExcelBanter - Hiding #N/A

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Hiding #N/A (https://www.excelbanter.com/excel-discussion-misc-queries/103603-hiding-n.html)

FP Novice

Hiding #N/A

VBA Noob

Hiding #N/A

Hi,

Say A1 is a N/A error. the below if statement will return the text
"Error" if True or" No error" if False.

=IF(ISNA(A1),"Error","No Error")

Several tyoes of error

VBA Noob

--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=569187

All times are GMT +1. The time now is 04:01 PM.