vendredi 24 juillet 2015

IF/nested formula issue

=IF(AND(F2>0,F2<5),27,IF(AND(F2>4.99,F2<9),28.5,IF(AND(F2>8.99,30)))

This is my formula. Cell F2 has the number of years of service of an employee. I need to calculate different pay rates per employee - 1-4 years = $27; 5-9 years=28.5; and 10+ years=30. I keep getting an error in my formula and cannot figure out why.

Aucun commentaire:

Enregistrer un commentaire