MrExcel Publishing
Your One Stop for Excel Tips & Solutions

gradebook


Posted by Mary on June 14, 2001 6:53 AM

I think this is probably simple but I am new to this.
Thank you. How do I modify the equation below to round up if the answer is .5 or above?
?
For example, if the answer comes out to 85.5? How do I get that to print simply as 86?
And can I also get answers which comes out below .5 to simply print out as the lower whole number? For example 85.4 printing as 85.

Here's the equation: =AVERAGE(T8+U8)+1

T represents test avg

U represents homework avg

I want to calculate a final average as a whole number plus 1


Posted by Aladin Akyurek on June 14, 2001 6:56 AM

=ROUND(AVERAGE(T8+U8),0)+1

Aladin

Posted by Joe Was on June 14, 2001 8:20 AM

I use a formula for this problem.
=ROUND(AVERAGE(T8U8+1),0)
this gives to the whole lowest whole number rounded up.
The ROUND syntax is ROUND(Formula or Address,code)
code: 0 = nearest one place.
1 = nearest 1/10th
2 = nearest 1/100th
-1 = nearest ten's
-2 = nearest hundred
etc.
You can nest the ROUND function as much as you want, to condition elements of your formula. JSW