I tried that. It does not seem to be capturing the change in VarianceAre your calculations set to manual or automatic?
What if you press the F9 key? then does it change?
Also, are your "TRUE" values boolean, or text?
If boolean, you need to remove the double-quotes from around all the TRUE values in your formula.
It should only show "Adjust" if all requirements are metLooks correct to me. None of P, Q, R are TRUE, so it should return "Adjust".
Any suggestions on what to change?Your formula only shows "Do Not Adjust" if all the conditions are met.
It sounds to me like you may have your "Do Not Adjust" and "Adjust" arguments reversed.Any suggestions on what to change?
How do I add a third argument ?It sounds to me like you may have your "Do Not Adjust" and "Adjust" arguments reversed.
Basically, an AND formula says if ALL these conditions are met, return this value (the second argument).
In all other cases, return the value in the third argument.