Please correct this Excel function...

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