H
Helen Shah
I am trying to add values based on performance rating and merit guidelines
validating if Managers are within or outside merit guidelines. I am trying
to use If AND function in the following example:
Column C Column F Result
Column
Performance Rating Merit Guideline Merit % Within or Outside Merit
Outstanding 3% - 3.5% 3.00% FALSE
Good 2% - 2.5% 5.00% FALSE
=IF(AND(C4="Outstanding",F4<3%,F4>3.5%),
IF(AND(C4="Good",F4<2%,F4>2.5%),"Outside","Within"))
Where Column C = Performance Rating
Column F = Actual Merit % entered
Result Column = Indicate if Outside or Within Guideline using IF function
I can not get the formula to work. We have a 5 scale performance rating and
would need to add into the IF function. The formula is giving me the value as
"FALSE". Would appreciate any help I can get.
validating if Managers are within or outside merit guidelines. I am trying
to use If AND function in the following example:
Column C Column F Result
Column
Performance Rating Merit Guideline Merit % Within or Outside Merit
Outstanding 3% - 3.5% 3.00% FALSE
Good 2% - 2.5% 5.00% FALSE
=IF(AND(C4="Outstanding",F4<3%,F4>3.5%),
IF(AND(C4="Good",F4<2%,F4>2.5%),"Outside","Within"))
Where Column C = Performance Rating
Column F = Actual Merit % entered
Result Column = Indicate if Outside or Within Guideline using IF function
I can not get the formula to work. We have a 5 scale performance rating and
would need to add into the IF function. The formula is giving me the value as
"FALSE". Would appreciate any help I can get.