=IF(C5=11.5%+1%*MEDIAN(1,B5,6),5,IF(C5=10.25%+1% *MEDIAN(1,B5,6),4,IF(C5=8.25%+1%*MEDIAN(1,B5,6),3 ,IF(C5=7%+1%*MEDIAN(1,B5,6),2,IF(C5=0,1,"N/A")))))
--
David Biddulph

"57Caddy" wrote in message
...
We would like to have a formula that will calculate differently based on
Tenure of our staff. Column B will hold the Tenure. So say cell B5 equals
6
or greater,
then

=IF(C5=17.5%,5,IF(C5=16.25%,4,IF(C5=14.25%,3,IF (C5=13%,2,IF(C5=0,1,"N/A")))))

and if B5 equals 5 then

=IF(C5=16.5%,5,IF(C5=15.25%,4,IF(C5=13.25%,3,IF (C5=12%,2,IF(C5=0,1,"N/A")))))

and so on down to B5 equaling down to 1 or less.

How do I do this? Forgive me for being kind of a hack.

Max had tried to help earlier but had a part of the formula I didn't
understand.

Thank you