Hi
I have a cell that contains a function which returns the average of a set of
numbers. I want the result to then be converted to the nearest whole number
if the decimal is 5 or greater. and down if 4 or less

i.e an average of 3,4 or less would round down to 3 and an average 0f 3.5 or
over would round up to 4.

I have been trying to nest the average and round functions in the same cell.
I can't find a varition of the round function to do this or find anything in
help.
Assitance appreciated.

=ROUND(AVERAGE(A1:A5);0)

--
HTH

Bob Phillips

"kim" wrote in message
...
Hi
I have a cell that contains a function which returns the average of a set
of
numbers. I want the result to then be converted to the nearest whole
number
if the decimal is 5 or greater. and down if 4 or less

i.e an average of 3,4 or less would round down to 3 and an average 0f 3.5
or
over would round up to 4.

I have been trying to nest the average and round functions in the same
cell.
I can't find a varition of the round function to do this or find anything
in
help.
Assitance appreciated.