I have a spreadsheet that has various columns of data that I want to iterate through and check their value, some cells have #REF in them because they have links to unavailable spreadsheets.
if I loop through each cell in a column and check it’s value is above an absolute level and that the total value of non 0 values isn’t greater than another value, I have a problem. Because the read cell output of reading an error value if you convert it to a string is -2146826265 which throws off all my absolute value checks and totals.
Does anyone have an idea what to do please. [Errors.zip|attachment
Don’t worry about the looping just want to know how to ignore the error values.
I’ve attached an example.
Errors.zip (18.4 KB)
Thanks in advance