Hi guys,

I have a table that looks like the following:

Status Age
Local 2
Expat 3
LOCAL 4
expat 5
Local 6

The logical tests should be, if age=2 then NO, if age=3 or 4 then .75, if age = 5 of above then 1. However, all the previous is only applicable if the person is an Expat. I.e. if they are local, then no matter what age it should return NO.

I've put in this formula but it says I have too many arguments:

=IF(N22<3,"NO",IF(AND(N22=3,J22="expat"),0.75,"NO",IF(AND(N22=4,J22="expat"),0.75,"NO",IF(AND(N22=5,J22="expat"),1,"NO",IF(AND(N22>5,J22="expat"),1,"NO")))))

I can't get it to work... any help would be greatly appreciated!