=IF(AND([Job Status]=“FT”,[Years Service]>=1,[Annual Salary]*0.03,0)
Than you.
=IF(AND([Job Status]=“FT”,[Years Service]>=1,[Annual Salary]*0.03,0)
Than you.
Right off the bat I can see you’re missing a right parenthesis at the end somewhere. But what is the function suppose to do? It sort of falls apart at the end right now.
=IF(AND([Job Status]=“FT”,[Years Service])>=1,[Annual Salary]*0.03,0)
Gotta complete your AND function muchacho
ETA: For some reason I’ve never been able to make >= work.
erleichda: As nivlac and Inigo Montoya pointed out, you are missing a right parenthesis to end the AND function.
:smack: Right paren goes AFTER the 1.
I am also missing a “k” in thank you!
I figured it out on my own, but thank you all anyway for your replies.