Yes thank you very much I figured it out this morning just one little mistake
i guess is all it takes
thank you for your reply

"David Biddulph" wrote:

Your AVERAGE function does nothing if you've given it only one argument.
=ROUND(AVERAGE(C19),0) is the same as =ROUND(C19,0)

In another branch of this thread you said you had =AVERAGE(August) in C19,
and I assume that August is a named range.
You could, therefore, use =ROUND(AVERAGE(August),0)
--
David Biddulph

"AmandaCollins" wrote in message
...
hi thank you for your time
i just thought i would let you know i have figured out my problem
i was entering =ROUND(AVERAGE(C19,0))
when it should have been =ROUND(AVERAGE(C19),0)
Thank you for your time though

"T. Valko" wrote:

You have to give us some details! Like:

Post the *exact* formula
Tell us *exactly* what cell that formula is entered in
If any of the values being averaged are the results of formulas, we'd
need
to know what those formulas look like and the *exact* location of those
formulas.

--
Biff
Microsoft Excel MVP


"AmandaCollins" wrote in
message
...
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...