Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,520
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
help with date funciton [email protected] Excel Worksheet Functions 3 May 1st 09 09:27 PM
match multiple criteria ina range from multiple criteria multiplet RG Excel Worksheet Functions 8 September 28th 07 04:21 AM
RANK Funciton Marcos Excel Worksheet Functions 1 November 10th 05 01:34 AM
Counting Cells with multiple criteria.One criteria supporting wild Azhar Saleem Excel Worksheet Functions 1 January 12th 05 11:54 AM
Counting Cells with multiple criteria.One criteria supporting wild Azhar Arain Excel Worksheet Functions 1 January 12th 05 09:33 AM


All times are GMT +1. The time now is 12:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"