I need to add rounding up to the following to finish a project =(B3*15%)+(C3*25%)+(D3*60%) (the columns shown are b,c,d,e,f) to make the grades whole numbers and the letter grade to change when rouded up. As it is if I make the bottom one 90 it still shows the grade as B because excel sees it as 89.6 instead of 90. Is it possible???
100 92 86 89.60 B
71 58 58 59.95 D
0 F
50 D
60 C
75 B
90 A
This is the grade scale with the lowest possible grade for that letter grade
Thanks for any help.
Hi Wallace,
In F3 you could try one of the following:
1. If you have your grade scale listed on the sheet, lets say in range A15:B19, then try:
This will round E3 to zero decimal places, then lookup that value in your grade scale range, A15:B19 in this case. The "2" tells it to return the value in the second column and the "1" tells it to return the largest value not greater than the value you're seeking. (A "0" there would only try to find an exact match to your value, which would fail unless the person actually scored a 0, 50, 60, 75 or 90.)
Please Login or Register to view this content.
2. If you don't have a grade scale on the sheet somewhere, and don't want one, you can use a LOOKUP formula like this one:
Let us know if you need anything else.Please Login or Register to view this content.
Or you could round within the original calculation, try this formula in E3
=ROUND(SUMPRODUCT(B3:D3,{0.15,0.25,0.6}),0)
Thanks to both!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks