MrExcel Publishing
Your One Stop for Excel Tips & Solutions


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



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

I use a formula for this problem.
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
You can nest the ROUND function as much as you want, to condition elements of your formula. JSW