An If/Then formula disabled the (related) IF/AND formula in the adjacent cell

Good morning!! 

I have nested If/and formulas in column C to determine, based on multiple criteria,  whether or not there is a requirement for a compliance document.

IF ([PO_Ceiling_Value]>[Threshold_Applicablilty],AND[Commercal_Item] are both YES,

then the document is REQUIRED

=IF(AND(B11>D23,B12="YES"),"REQUIRED","N/A")

and this worked fine. 

Until i put an IF/THEN formula in cell D23 (the threshold for applicability that will change between 2 values based on a Yes/No answer in B5) 

=IF(B5="YES","2500","10000")

The IF/THEN worked, changing the threshold back and forth based on YES/NO,

But now the nested IF/AND doesn't calculate results anymore.  😞 😞 😞 

In a nutshell, i need to lower the Threshold for Applicability (D23) to $2500 if it is an SCA Contract (B5=YES) and still have my nested formulas return calculated results based on the value $2500.

Why won't this work?  Is it a circular reference? I'm not getting that error.