If AND/OR funciton with multiple criteria
 

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%,F43.5%),
IF(AND(C4="Good",F4<2%,F42.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.

If AND/OR funciton with multiple criteria
 

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
---------------
Jacob Skaria


"Helen Shah" wrote:

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%,F43.5%),
IF(AND(C4="Good",F4<2%,F42.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.

If AND/OR funciton with multiple criteria
 

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


"Jacob Skaria" wrote:

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
---------------
Jacob Skaria


"Helen Shah" wrote:

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%,F43.5%),
IF(AND(C4="Good",F4<2%,F42.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.