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.