How to detect #VALUE! in cell from Excel?

1

I would like to calculate a new column "B" based on an existing column "A" that was imported from Excel. Column "A" has an error value that is displayed as #VALUE!. If I don't do anything special, Easymorph displays "#Reference to error in column". How can I detect this and handle it in my formula for Column "B"? I've tried using iserror, if not isnumeric, if "#VALUE!", if "VALUE!"... nothing I try seems to work.

2

Hi Frank and welcome to the Community!

This worked for me:

image
image1079×326 11.4 KB

3

Well that's embarrassing. Yes, that does indeed work perfectly. I had some other stuff included in my formula that was interfering with the iserror function. I should have thought to first simplify my formula. Thank you!

4

You're welcome! :slight_smile: