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

[VictoriaGilliam]

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.  

[#2 · Accepted solution]

@VictoriaGilliam 

"2500" and "10000" are text values, not numbers, so they mess up the comparison B11>D23.

Change the formula in D23 to

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

[#3]

OMG THANK YOU SO MUCH

I appreciate your help so much. I could NOT understand what i was missing here