View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default using the ROUND function in a cell that already has AVERAGE functi

Hi,

Your formula should look something like:

=ROUND(AVERAGE(A1:A10),0)

try entering the formula without the Function Argument stuff.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"AmandaCollins" wrote:

As soon as I enter my information into the Function Arguments dialogue box
the formula result is correct but when i hit enter it says stuff about a
circular reference but i have done everythign it tells me to and my teachers
cant figure it out either... Please help...