Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to round & sum only the displayed (rounded) numbers
I have rounded some numbers to the thousands digits. I need help finding a
formula that rounds the displayed (rounded thousands) digits. Everything I try only calculates it based on the unrounded numbers and as such many sum numbers are off by 1 (or really 1,000). Any help would be awesome! thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to round & sum only the displayed (rounded) numbers
On Fri, 19 Feb 2010 06:57:01 -0800, ALG wrote:
I have rounded some numbers to the thousands digits. I need help finding a formula that rounds the displayed (rounded thousands) digits. Everything I try only calculates it based on the unrounded numbers and as such many sum numbers are off by 1 (or really 1,000). Any help would be awesome! thanks It sounds as if you did NOT really round the numbers, but rather just changed the formatting in the cells. To ROUND a number, you need to use the ROUND function, or equivalent. e.g. A1: =your_formula vs A1: =ROUND(your_formula,2) --ron |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to round & sum only the displayed (rounded) numbers
To round thousands in the way you seem to want to you can use this formula:
=ROUND(A1,-3)/1000. This will round , for example, 1200 to 1 and 1650 to 2 and 32559 to 33. You can then use these numbers in your calculations. "ALG" wrote: I have rounded some numbers to the thousands digits. I need help finding a formula that rounds the displayed (rounded thousands) digits. Everything I try only calculates it based on the unrounded numbers and as such many sum numbers are off by 1 (or really 1,000). Any help would be awesome! thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add rounded numbers using the rounded value | Excel Discussion (Misc queries) | |||
ROUNDED NUMBERS | Excel Worksheet Functions | |||
Subtracting Rounded Numbers | Excel Discussion (Misc queries) | |||
numbers being rounded | New Users to Excel | |||
how do i add rounded numbers? | Excel Discussion (Misc queries) |