IF AND Not working correctly

[danniaus]

Hello

In Column Meter Type I have the following formula

=IF(AA2="LARGE",AND(AC2={"BASIC","MRIM"}),"Meter Requires Upgrade")

What I am trying to say is that if Column Classification contains the value "LARGE" AND column Meter Installation Code Contains the value "BASIC" OR "MRIM" then mark "Meter Requires Upgrade"

This doesn't appear to be working right as it only meeting one condition "LARGE"
[TABLE="class: grid, width: 1082"]
<colgroup><col span="2"><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Classification[/TD]
[TD]State[/TD]
[TD]Meter Installation Code[/TD]
[TD]Eligible for Pricing?[/TD]
[TD]NMI Acquisition or Renewal[/TD]
[TD]Threshold Calculation[/TD]
[TD]Meter Type[/TD]
[/TR]
[TR]
[TD]LARGE [/TD]
[TD]VIC [/TD]
[TD]SMALL[/TD]
[TD]Eligible for Pricing[/TD]
[TD][/TD]
[TD]>100[/TD]
[TD]Meter Requires Upgrade[/TD]
[/TR]
</tbody>[/TABLE]

Any help is appreciated

Thanks

Danni

 

[Michael M]

MAybe this

=IF(AND(AA2="LARGE",OR(AC2={"BASIC","MRIM"})),"Meter Requires Upgrade","METER OK")

 

[joeu2004]

[.... deleted by me .... michael beat me to it ....]

 

[Michael M]

Ha !....that would be a first. !!..

 

[danniaus]

Hi Michael,

Thanks for the quick reply.

Hmm this didn't work, it says Meter OK as the result. Because AA2 says LARGE AND AC2 = Basic it should say Meter Requires Upgrade...

 

[Michael M]

IS BASIC or basic....there is a difference ??
BASIC needs to be in capitals !

 

[danniaus]

Sorry I mistyped, yes BASIC and LARGE are both in capitals

 

[Michael M]

Works fine for me !
But if there is anything in AA2 apart from LARGE, it will say "meter OK"
So maybe another condition is required for AA2 ??

=IF(AND(AA2="LARGE",OR(AC2={"BASIC","MRIM"})),"Meter Requires Upgrade","METER OK")