If AND/OR funciton with multiple criteria

[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.

 

[Jacob Skaria]

Try the below

=IF(OR(AND(C4="Outstanding",F4>=3%,F4<=3.5%),
AND(C4="Good",F4>=2%,F4<=2.5%)),"Within","Outside")

If this post helps click Yes

 

[Helen Shah]

This works. Thanks a bunch!
--
fdmf;lds

Try the below

=IF(OR(AND(C4="Outstanding",F4>=3%,F4<=3.5%),
AND(C4="Good",F4>=2%,F4<=2.5%)),"Within","Outside")

If this post helps click Yes