ExcelBanter - Identifying #N/A cells

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Identifying #N/A cells (https://www.excelbanter.com/excel-worksheet-functions/56110-identifying-n-cells.html)

Lee Harris

Identifying #N/A cells

Just curious if there is a function you can use to put in an IF

eg
IF (ISERROR(A1),blah,blah)

tjtjjtjt

Identifying #N/A cells

ISNA

--
tj

"Lee Harris" wrote:

Just curious if there is a function you can use to put in an IF

eg
IF (ISERROR(A1),blah,blah)

All times are GMT +1. The time now is 10:02 AM.