If AND/OR funciton with multiple criteria

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

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
 
H

Helen Shah

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


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top