Excel - Comparing results/scores

January 2017




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


Published by aakai1056. Latest update on February 20, 2010 at 02:39 AM by aakai1056.
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).