IF(And statement not showing correct result

[JREYNA03]

I noticed that when I conditions change the result of "Adjustment", "Do Not adjust" does not change

=IF(AND(G2="Complete",N2="TRUE",O2="TRUE",P2="TRUE",Q2="True",R2="True"),"Do Not Adjust", "Adjust")

 

[JREYNA03]

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.

 

[RoryA]

You had this:

=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:

=IF(AND(G2="Complete",N2="TRUE",O2="TRUE",P2="TRUE",Q2="True",R2="True"), "Adjust","Do Not Adjust")

 

[JREYNA03]

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.

Not working

 

[RoryA]

Q2 contains 1, not TRUE, so not all your conditions are met, and therefore you get the "Adjustment needed" result.

 

[JREYNA03]

You had this:

=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:

=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.

 

[RoryA]

I shouldn't have copied from your original formula as I forgot you had quotes in there:

=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.

 

[JREYNA03]

When the variance adjustment is made the result doesn't update almost like it doesn't recognize the cell.

 

[JREYNA03]

I shouldn't have copied from your original formula as I forgot you had quotes in there:

=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 see the Q2. I adjusted that one.
When the variance adjustment is made the result doesn't update almost like it doesn't recognize the cell.

 

[RoryA]

Again, you need to remove the quotes around True in your formula.

 

[JREYNA03]

Again, you need to remove the quotes around True in your formula.

I tried but it doesn't change the results