Excel - Comparing results/scores
Issue
I want to compare possible GPA and LSAT scores to Minimum Acceptance GPA and LSAT scores. I've tried using IF and AND functions, but I can't seem to get it right.
Output Example:
GPA: 2.71
LSAT Score: 148
University of Alabama 3.3 160 No
University of Memphis 3.1 151 No
Harvard School of Law 4.0 180 No
Matchbool School of Law 1.0 50 Yes
Solution
Assumption:
- 1. student GPA is in cell B2 and LSAT is in cell C2
- 2. universities required GPA is starts at B3 and down
- 3. universities required LSAT is in cell C3 and down
- 4. decision for each university is to be shown in cell d3 and down
- 5. For "yes" decision, the user GPA and LSAT both must be greater or equal to university requirement
Write this in cell d3 and then copy down:
=IF( AND(B$2 >= B3, C$2 >= C3), "YES", "NO")
Note
Thanks to rizvisa1 for this tip on the forum.
Related
- Excel - Comparing results/scores
- Excel compare two columns for partial matches - Guide
- Excel - Compare two lists and change row color - How-To - Excel
- Excel - Compare column A & B give results in column C - How-To - Excel
- Excel - Compare data from two columns - How-To - Excel
- Excel compare two sheets - Guide
This document, titled « Excel - Comparing results/scores », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).