You already have it. An IF has three arguments:
=IF(condition to check,what to return if condition is true,what to return if condition is false)
You have "Do Not Adjust" as your 2nd argument and "Adjust" as your third argument.
If what you said in post 5 is true, then you just need to change those two arguments around.
=IF(AND(G2="Complete",N2="TRUE",O2="TRUE",P2="TRUE",Q2="True",R2="True"),"Do Not Adjust", "Adjust")
=IF(AND(G2="Complete",N2="TRUE",O2="TRUE",P2="TRUE",Q2="True",R2="True"), "Adjust","Do Not Adjust")
You already have it. An IF has three arguments:
=IF(condition to check,what to return if condition is true,what to return if condition is false)
You have "Do Not Adjust" as your 2nd argument and "Adjust" as your third argument.
If what you said in post 5 is true, then you just need to change those two arguments around.
When the variance adjustment is made the result doesn't update almost like it doesn't recognize the cell.You had this:
Excel Formula:=IF(AND(G2="Complete",N2="TRUE",O2="TRUE",P2="TRUE",Q2="True",R2="True"),"Do Not Adjust", "Adjust")
but it seems it should have been:
Excel Formula:=IF(AND(G2="Complete",N2="TRUE",O2="TRUE",P2="TRUE",Q2="True",R2="True"), "Adjust","Do Not Adjust")
=IF(AND(G2="Complete",N2=TRUE,O2=TRUE,P2=TRUE,Q2=True,R2=True), "Adjust","Do Not Adjust")
When the variance adjustment is made the result doesn't update almost like it doesn't recognize the cell.
I see the Q2. I adjusted that one.I shouldn't have copied from your original formula as I forgot you had quotes in there:
Excel Formula:=IF(AND(G2="Complete",N2=TRUE,O2=TRUE,P2=TRUE,Q2=True,R2=True), "Adjust","Do Not Adjust")
but again note that 1 does not equal TRUE, and column Q appears to have numbers in it, not True/False values.
I tried but it doesn't change the resultsAgain, you need to remove the quotes around True in your formula.