View Full Version : Multiple criteria comparing
sachin483
08-11-2015, 09:40 PM
I want to check if the person data has qualified or not with this criteria , it should compare data 3 column with criteria 3 column and the result should be in "Yes" or "No"
CRITERIA
DATA
DESG
ACH
GROWTH
DESG
GROWTH
ACH
RESULT
FORMULA
AA
105
195000
AA
185000
115
Yes
AA
110
140000
AA
120
110000
wrightyrx7
08-12-2015, 02:50 AM
I think we need more information like when the result would be YES and when it would be NO.
You have the result in your example as YES but the data does not match anything in the Criteria.
Aussiebear
08-12-2015, 03:20 AM
I have to agree with wrightyrx7, for given the example in post#1, the AA matches, ACH is above, but growth is less than yet the result is a Yes. Can you explain what rules you are applying to the comparison?
sachin483
08-12-2015, 04:25 AM
If the person has achieved more than the require by the company he will get the gift in kind hence "Yes" is require if not achieved then "No" but there are 3 criteria for person to be eligible for eg:- AA- DESG has achieved 115 ach% and 185000 growth hence has succeeded in second criteria ie:- 110% and 140000 growth for AA - desg
Aussiebear
08-12-2015, 04:54 AM
Thank you for clarifying this issue.
sachin483
08-12-2015, 10:21 PM
can anyone help me out with excel formula
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.