Help with applying ROUND function

  • Thread starter Thread starter evenflow814
  • Start date Start date
E

evenflow814

I am having trouble applying the ROUND function to a formula, where I
need to figure the weighted average of graded assignments and then
ROUND the response to the nearest number.

The original formula I used is as follows:
=SUM((C10+D10+G10)/3*0.25+((E10+H10)/2*0.25+(F10*0.5)))

The response I get is:
86.9583

I need to get to the point where the response is ROUNDED to 87.

How can I apply the ROUND function to the response of the above SUM
function to get this rounded number?

Thanks for your time!
 
=ROUND(SUM((C10+D10+G10)/3*0.25+((E10+H10)/2*0.25+(F10*0.5))),0)


--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
You do not need the SUM function here.
This =SUM((C10+D10+G10)/3*0.25+((E10+H10)/2*0.25+(F10*0.5)))
is the same as =(C10+D10+G10)/3*0.25+(E10+H10)/2*0.25+F10*0.5
So to round it use =ROUND((C10+D10+G10)/3*0.25+(E10+H10)/2*0.25+F10*0.5, 0)
best wishes
Bernard
 
Back
Top