| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get a sum to round?
I have my formula, but I need the answer to round? Thanks.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get a sum to round?
=ROUND(SUM(A1:A10),0)
HTH. Best wishes Harald "tcarman" skrev i melding ... I have my formula, but I need the answer to round? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get a sum to round?
=round(sum(range),number of digits)
-- Brevity is the soul of wit. "tcarman" wrote: I have my formula, but I need the answer to round? Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I get a sum to round?
Thanks!
"tcarman" wrote: I have my formula, but I need the answer to round? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Roundup or Ceiling Function to round to a specific number | Excel Discussion (Misc queries) | |||
| ROUND or "Precision as displayed"? | Excel Worksheet Functions | |||
| Round a number in nested function | Excel Worksheet Functions | |||
| Round whole numbers up and down | Excel Discussion (Misc queries) | |||
| How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
Linear Mode
