Formula not recognizing value in referenced cell

[klynshoe]

I have a formula that references the numeric value of another cell with a formula. It doesn't work.... how can I fix this?

Non-Working Formula: =IFERROR(IF(OR(F8/D8>0.05,F8=E8),"X",""),"")

Referenced Formula in F8: =IF(E8="","",IFERROR(E8-D8,""))

Where the value in cell F8 and E8 is both 11, the result should be "X" since F8=E8 but it does not, it gives me "" (blank).


USING EXCEL 2010

Thank you,

Kelly

 

[Jonmo1]

And if D8 does equal zero, shouldn't the "F8=E8" override that in the OR function?

No.
OR(F8/D8>0.05,F8=E8)

If D8 = 0, then F8/D8 = #Div/0!
Any Formula error within the OR will propagate to the overall result of the OR.
Regardless of the results of the other arguments in the OR.

 

[Jonmo1]

The problem with your solution is that I still want an "X" if F8=E8, when D8 = 0.

Then we test for that condition FIRST


Try
=IF(F8=E8,"X",IF(D8=0,"",IF(F8/D8>0.05,"X","")))