View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default 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?