Advanced Filter not using formula value in criteria

[Dennis]

I've created an Advanced Filter function that extracts
records from a data range based on a criteria value.
When the formula in the data range is simple (=F5-E5) and
the value is some number, when the critera specifies <>0,
all of the non-zero rows are extracted. When I use a
complex formula (=IF(OR(F5=E5,h5=G5),"0",H5-G5)), even
though it displays a zero (0, not the letter O), the
extract pulls it our as if it were a non-zero character.
If I manually put a 0 in the cells, it works correctly.
It is as if the "0" value is not numeric and is
calculated as non-zero. By the way, the cell format is
Numeric.

 

[Debra Dalgleish]

Change the "0" to 0 (remove the quotation marks)

I've created an Advanced Filter function that extracts
records from a data range based on a criteria value.
When the formula in the data range is simple (=F5-E5) and
the value is some number, when the critera specifies <>0,
all of the non-zero rows are extracted. When I use a
complex formula (=IF(OR(F5=E5,h5=G5),"0",H5-G5)), even
though it displays a zero (0, not the letter O), the
extract pulls it our as if it were a non-zero character.
If I manually put a 0 in the cells, it works correctly.
It is as if the "0" value is not numeric and is
calculated as non-zero. By the way, the cell format is
Numeric.

 

[Guest]

Thank you--we figured it out ourselves. I only wish the documentation were more clear on that. I didn't know there was a difference between a text zero and a numeric zero.