![]() |
|
#1
|
|||
|
|||
![]()
I am trying to Get a Letter grade via a VLOOKUP function.
Example: Total points possible: 75 My test results: 63 Percentage: 84% Letter Grade (B) I get #N/A Formula for Percentage =IF(C10="","",IF(C10=>0,+(C10/B10)*100)) Formula for Letter Grade =VLOOKUP(D10,$b$55:$C$66,1,TRUE) |
#2
|
||||
|
||||
![]()
Please don't post the same question multiple times - and don't post Excel questions in the Word forum. I've deleted your duplicate.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
Looking at your vlookup formula the issue appears that you have not given enough possibilities to calculate your score. Formula for Letter Grade
=VLOOKUP(D10,$b$55:$C$66,1,TRUE) B55 to C66 is only 11 possibilities but if you have scores ranging from 10% to 100% you will need a lot more. Also the lookup is looking in column 1 when I think it should be looking for the 2nd column. I think if you fix up your range with the scores and then change your vlookup to Code:
Formula for Letter Grade =VLOOKUP(D10,$B$55:$C$146,2,0) Thanks EDIT: Sorry I just reread that the score could go up to 75 points not 100 so that would need to be adjusted. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
jassi.mgg@gmail.com | Excel | 5 | 03-16-2014 01:47 AM |
Using vlookup with the IF function | CSzoke | Excel | 11 | 06-01-2013 10:56 PM |
Auditing Dependent Cells | WildBill | Excel | 2 | 09-07-2011 10:14 AM |
![]() |
Delson | Excel | 4 | 02-08-2010 01:27 PM |