using the ROUND function in a cell that already has AVERAGE functi

  • Thread starter Thread starter AmandaCollins
  • Start date Start date
A

AmandaCollins

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.
 
AmandaCollins said:
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...
Click to expand...

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.
 
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?
 
Thank sfor your reply I got it figured out now

Shane Devenshire said:
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
Click to expand...
 
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
 
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
 
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)
 
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
 
Back
Top