Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help with formula
I'm trying to figure out if there's a formula I can use to auto-enter my GPA
on a spreadsheet I have for school. I have a column with my current grade percent and a table that shows the percent ranges with the corresponding GPA....(i.e. my grade column shows 96.00% and the table shows 90-100% equal to 4.0 89-85% equal to 3.5 etc) Is there a way to have excel look at the 96.00% then reference the percentage range in the table and auto-enter into another cell the corresponding GPA? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
need help with formula
Say your datalist is in Y1 to Z9, with the GPA in Z1 to Z9, and the *lower*
grade percent of the range in Y1 to Y9, sorted ascending: For example, Y1 to Y9: 0, 55, 60, 65, 70, 75, 80, 85, 90 And Z1 to Z9: 0, 0.5, 1.0, 1.5, 2.0, 2.5, 3.0, 3.5, 4.0 With a grade percent in A1, enter this formula in say B1 to return the GPA to B1: =LOOKUP(A1,Y1:Z9) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "sn0w0wl" wrote in message ... I'm trying to figure out if there's a formula I can use to auto-enter my GPA on a spreadsheet I have for school. I have a column with my current grade percent and a table that shows the percent ranges with the corresponding GPA....(i.e. my grade column shows 96.00% and the table shows 90-100% equal to 4.0 89-85% equal to 3.5 etc) Is there a way to have excel look at the 96.00% then reference the percentage range in the table and auto-enter into another cell the corresponding GPA? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|