0
Thanks

A few words of thanks would be greatly appreciated.

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.

0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
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).