Sum and rounding functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
=ROUND(SUM(rng),2)

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
Sure. For instance:

=ROUND(SUM(A1:A6),2) will round the sum of a1 through a6 to two digits
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum Column above current cell dynamically using function call 7
the decimals extends after the sum function 2
Footing rounded numbers 4
Rounding down with a calculation 3
A rounding function 4
SUMIF on a Calculated Field 3
IF AND Nested Functions - Formula Not Working 0
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12

Back
Top