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