ExcelBanter - Sum and rounding functions

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Sum and rounding functions (https://www.excelbanter.com/excel-worksheet-functions/89383-sum-rounding-functions.html)

colleen

Sum and rounding functions

Is there any way to have 2 functions in one cell? I have a =sum function in
a cell and i want to round that value from that function can it be done?

Bob Phillips

Sum and rounding functions

=ROUND(SUM(rng),2)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"colleen" wrote in message
...
Is there any way to have 2 functions in one cell? I have a =sum function
in
a cell and i want to round that value from that function can it be done?

dspratley

Sum and rounding functions

Sure. For instance:

=ROUND(SUM(A1:A6),2) will round the sum of a1 through a6 to two digits

"colleen" wrote:

Is there any way to have 2 functions in one cell? I have a =sum function in
a cell and i want to round that value from that function can it be done?

All times are GMT +1. The time now is 08:14 AM.