Excel: If statement with #N/A
Solution 1:
Try using the ISNA() function:
=IF(ISNA(AR6347),"","string in here")
Solution 2:
In Excel 2007 and later you're able to use:
=IFERROR(A1;"")
to replace ="#N/A" or any other error with empty string.
Try using the ISNA() function:
=IF(ISNA(AR6347),"","string in here")
In Excel 2007 and later you're able to use:
=IFERROR(A1;"")
to replace ="#N/A" or any other error with empty string.