- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Microsoft Excel help
Posted on 1/26/14 at 6:39 pm
Posted on 1/26/14 at 6:39 pm
I need to enter the NCAA sliding scale for high school graduates GPA vs ACT scores into excel. Simply put, I have a spreadsheet built that calculates an athlete's GPA already. I would like the GPA to reference the sliding scale and spit out what ACT score is needed to meet the eligibility requirements. Thanks
4
Posted on 1/26/14 at 6:41 pm to bengaltygers
If you work for the NCAA Clearinghouse, no wonder why LSU sucks at getting players in without any problems 
Posted on 1/26/14 at 6:42 pm to bengaltygers
If function.
Posted on 1/26/14 at 6:42 pm to bengaltygers
Pretty simple. Use vlookup formula.
Posted on 1/26/14 at 6:54 pm to bengaltygers
Your request is worded funny but it sounds like a VLOOKUP formula will help you here
Posted on 1/26/14 at 7:18 pm to JumpingTheShark
Thanks alot. Im going to start playing around with it. Another factor I will run into is the sliding scale has GPA's listed in .025 increments. How do I get it to reference the row nearest the value but not going over? For instance, the scale says if you get a 2.500 GPA, your ACT sum needs to equal 68, if your GPA is 2.525, your ACT sum needs to equal 67.
How do I get it to calculate a GPA of lets say 2.510? I would want it to round down to the 2.500 row. Thanks
How do I get it to calculate a GPA of lets say 2.510? I would want it to round down to the 2.500 row. Thanks
Posted on 1/26/14 at 8:30 pm to bengaltygers
Ok now I'm confused. The VLOOKUP formula works perfectly except it only recognizes the first 57 lines of the table. The table is 63 lines long. I checked the array of the lookup and it includes all 63 lines.
edit: Forget the situation in my last post, I found a work around.
edit: Forget the situation in my last post, I found a work around.
This post was edited on 1/26/14 at 8:31 pm
Posted on 1/26/14 at 10:32 pm to bengaltygers
Sorry I just saw your response did you get it figured out?
Posted on 1/26/14 at 11:26 pm to bengaltygers
quote:
For instance, the scale says if you get a 2.500 GPA, your ACT sum needs to equal 68, if your GPA is 2.525, your ACT sum needs to equal 67.
If they need a 68 on their ACT then they are fricked.
Posted on 1/27/14 at 12:08 am to bengaltygers
I could be reading your request wrong, but it sounds like you need to combine 2 different formulas (vlookup, round)
For example:
=round(vlookup(gpa,gpa:actscore,2,0),1)
=rounded act score that is needed for that particular gpa
Switch gpa and act score if doing it the other way.
For example:
=round(vlookup(gpa,gpa:actscore,2,0),1)
=rounded act score that is needed for that particular gpa
Switch gpa and act score if doing it the other way.
This post was edited on 1/27/14 at 12:10 am
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News