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...

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...

"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...

First, what does this have to do with "ROUND in a cell that already has
AVERAGE"? I wonder if there is something more to the situation than simply
"entering information into the dialog box".

Second, circular references can be difficult to nail down, especially if
they are so opaque that "teachers" cannot figure it out. I presume they are
Excel teachers. But even if they are not, the point is: if more than one
other pair of eyes have already looked at the problem, either they did not
have all the information themselves, or the circular reference is very
obscure.

I suspect the most expeditious way for you to get help is to make the
worksheet available. However, you cannot attach Excel files to postings
that you submit through the MS web interface, which apparently you are
using.

Feel free to send it to me via email. Send to joeu2004 "at" hotmail.com.
Be sure to identify the cell whose formula is giving you problems, just in
case I do not encounter any. (By the way, I can only handle Excel 2003
files.)

But if you want to provide some additional information here first, I think
we need to know the name of the cell the formula is in as well as the
formula itself. We also might need to know the formulas in each cell
referenced directly or indirectly.

As you can imagine, that requirement can amount to a whole lot of
information. Hence the suggestion to share the entire worksheet, one way or
another.

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...

The formula in the cell that is already there is =AVERAGE(August) in Cell C19
what i need to do is use the ROUND function to round the calculation results
to the nearest dollar
Is that what you need to know?

"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...

Thank sfor your reply I got it figured out now

"Shane Devenshire" wrote:

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...

hi after i sent you the email i figured it out
I had to type =ROUND(AVERAGE(C19),0)
i was putting C19,0 in brackets and that was my problem
thanks for your help

"JoeU2004" wrote:

"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...

First, what does this have to do with "ROUND in a cell that already has
AVERAGE"? I wonder if there is something more to the situation than simply
"entering information into the dialog box".

Second, circular references can be difficult to nail down, especially if
they are so opaque that "teachers" cannot figure it out. I presume they are
Excel teachers. But even if they are not, the point is: if more than one
other pair of eyes have already looked at the problem, either they did not
have all the information themselves, or the circular reference is very
obscure.

I suspect the most expeditious way for you to get help is to make the
worksheet available. However, you cannot attach Excel files to postings
that you submit through the MS web interface, which apparently you are
using.

Feel free to send it to me via email. Send to joeu2004 "at" hotmail.com.
Be sure to identify the cell whose formula is giving you problems, just in
case I do not encounter any. (By the way, I can only handle Excel 2003
files.)

But if you want to provide some additional information here first, I think
we need to know the name of the cell the formula is in as well as the
formula itself. We also might need to know the formulas in each cell
referenced directly or indirectly.

As you can imagine, that requirement can amount to a whole lot of
information. Hence the suggestion to share the entire worksheet, one way or
another.

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...

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...

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...