I have over 6000 records and half of them are formulas that are missing a variable so they result in
#N/A on the spreadsheet, what i want to do is if the cell is
#N/A then leave the cell blank, otherwise print a string like so
=IF(AR6347="#N/A","","string in here")
But this does not work with
="#N/A", is there a way to do this?