Round a number in nested function

[kim]

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.

[Bob Phillips]

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

--
HTH

Bob Phillips

"kim" <[email protected]> wrote in message
news:[email protected]...
> 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.
>