Testing for #VALUE

[Abraxus]

I have an Excel spreadsheet that holds a table updated by Power Query.

Some of the returned cells are empty. If I try to get the value of those cells, I get #VALUE.

That's ok, but I need to test those cells to see if:

• The cell = 0

• The cell hold a numeric value

How can I test those cells to see if they are 0 or not without getting #VALUE on the rows with nothing in that field?

[HansV]

Perhaps you can use the IFERROR function.

Otherwise: could you attach a small sample workbook demonstrating the problem without sensitive/proprietary data?

[Abraxus]

Let's try this. You can see in the last column that testing for 0 isn't working.

[HansV]

You could use

=IF(IFERROR(VALUE([@[CO_Amend_Value]]),1)=0,"True","False")

or

=IF([@[CO_Amend_Value]]="", "False", IF(VALUE([@[CO_Amend_Value]])=0,"True","False"))

or even

=IFERROR(VALUE([@[CO_Amend_Value]])=0,FALSE)