When you use the AVERAGE Function on Excell, how do you ROUND it as well?

Question

While using Microsoft Excel..I want to use the AVERAGE Function, but also use the ROUND function on it, by rounding to its nearest integer

Answer 1

=ROUND(AVERAGE(A2:A6),0)



if you have following data from A2 to A6 :

A2 25

A3 55

A4 61

A5 97

A6 38



without round function like

=AVERAGE(A2:A6) will give you result 55.2 whereas round function will come out with 55 as average duly rounded to nearest integer.

Answer 2

You click on the .00->.0 button while selecting the affected boxes until you get the rounding you desire.

Answer 3

properly, those women are idiots. even inspite of the incontrovertible fact that that's real that girls are actually not reliable judges of penis length, using fact we experience them interior us, and girls's vaginas do stretch in the time of intercourse. My bf is familiar sized, yet whilst he's interior me, he feels extensive to me and each from time to time that's even a war to get him in. even inspite of the incontrovertible fact that, I even have additionally observed adult adult males complaining they're "too small" at 7 inches, that's clearly greater desirable than prevalent or a minimum of interior the top variety of prevalent.

Answer 4

USE THE SHIFT KEY AND PRESS F8

Answer 5

=ROUND(AVERAGE(XY:XY))