# Excel - Comparing results/scores

October 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.