5
57Caddy
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
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