Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with date funciton | Excel Worksheet Functions | |||
match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
RANK Funciton | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions |