Round round get around

[Nick]

Hi,
I was wondering if there was away I could nest a round
function with some other function, and not get a circular
reference.

Eg, In cell B11, say I want the sum of column b rounded,
this comes up with a circular ref:
=Sum(b1:b10),=round(B11,2).

Thanks for help

Nick

 

[Frank Kabel]

Hi
try the following formula in B11
=ROUND(SUM(B1:B10),2)

 

[Norman Harker]

Hi Nick!

Do you want:

=ROUND(SUM(B1:B10))
This sums B1:B10 and rounds the answer

OR:

=SUM(ROUND(B1:B10))
Entered as an array by pressing and holding down Ctrl+Shift and then
pressing Enter.

This sums the rounded values of B1:B10


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.