Hello,

Me and a co-worker have been working on an issue we are trying to figure
out. We have a basic formula but need it to apply different ratings based on
a person's tenure. Tenure will be in Column C. I will put below what we would
like to do, so if anyone has any easy suggestions, we are all ears. I say
easy because we will need to replicate it about six times for different
fields all based on tenure.

Thank you

Now if C5=6 then we would like:

=IF(R5<235,5,IF(R5<=245,4,IF(R5<=255,3,IF(R5<=280, 2,IF(R5280,1) ) ) ) )


Or if C5=5 then we would like:

=IF(R5<240,5,IF(R5<=250,4,IF(R5<=260,3,IF(R5<=285, 2,IF(R5285,1) ) ) ) )


or if C5=4 then we would like:

=IF(R5<245,5,IF(R5<=255,4,IF(R5<=265,3,IF(R5<=290, 2,IF(R5290,1) ) ) ) )


or if C5=3 then we would like:

=IF(R5<250,5,IF(R5<=260,4,IF(R5<=270,3,IF(R5<=295, 2,IF(R5295,1) ) ) ) )


or if C5=2 then we would like:

=IF(R5<255,5,IF(R5<=265,4,IF(R5<=275,3,IF(R5<=300, 2,IF(R5300,1) ) ) ) )


or if C5=1 then we would like:

=IF(R5<260,5,IF(R5<=270,4,IF(R5<=280,3,IF(R5<=305, 2,IF(R5305,1) ) ) ) )


Thanks again.