electronic gradebook
how do i put in the formula to get a letter grade by using percentage. for
instace 100 - 90 = A 89 - 70 = B and so on using Excel. |
electronic gradebook
shug, Try this, =IF(A2=90,"A",IF(A270,"B",IF(A269,"C",IF(A250, "D","F")))) HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=555051 |
electronic gradebook
Nel post
*shug* ha scritto: how do i put in the formula to get a letter grade by using percentage. for instace 100 - 90 = A 89 - 70 = B and so on using Excel. You can use VLOOKUP with last parameter set to TRUE. You have to build a table, in ascending order of values, and then use the VLOOKUP function. -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
electronic gradebook
=IF(A189,"A",IF(A169,"B",IF(A159,"C",IF(A149," D",IF(A1<50,"F",0)))))
You will of course have to change the numbers in the formula for your D and F etc. "shug" wrote: how do i put in the formula to get a letter grade by using percentage. for instace 100 - 90 = A 89 - 70 = B and so on using Excel. |
electronic gradebook
shug
To convert scores to letter grades use a Lookup table and VLOOKUP functions. OR a Lookup formula without a table Assuming scores are in column A starting at A1. In B1 enter this formula then drag/copy down column B =LOOKUP(A1,{0,31,41,51,61,71,81,91,101},{"E","D"," C-","C","C+","B","B+","A"}) Example only. Adapt for your scores and grades. Note the curly braces internally. Gord Dibben MS Excel MVP On Fri, 23 Jun 2006 09:57:02 -0700, shug wrote: how do i put in the formula to get a letter grade by using percentage. for instace 100 - 90 = A 89 - 70 = B and so on using Excel. Gord Dibben MS Excel MVP |
All times are GMT +1. The time now is 11:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com