Problem with criteria

[Unicon]

Dear all,

Please see the attachment. I am struggling with criteria. Please advice for the solution.

 

[DCrake]

You have AD appearing twice one with 2500 and one with 2000. Your iif statement is working correctly.

 

[Unicon]

Thanks DCrake,

My problem is there is so many staff in AD with 2000 salary and out of that I have some staff that is having salary more than 2000 in same states. Here the problem is my criteria will say whoever work in AD/SHJ/FUJ they will entitled for 2000 but in the condition of ID no. 100001 and other his basic entitlement is 2500, I want to so that even he is working in AD his basic entitlement is 2500.

 

[Brianwarnock]

but in the condition of ID no. 100001 and other his basic entitlement is 2500

Does this mean that there are more exceptions, if so you will probably have to use code, but in any case you will need to check for this (these) Ids .

Brian