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.
Bookmarks