Forum Discussion
Solved
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]>[T...
"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)
"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)
OMG THANK YOU SO MUCH
I appreciate your help so much. I could NOT understand what i was missing here
I appreciate your help so much. I could NOT understand what i was missing here