Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding
I am summing cells that are based on the results of a formula and the result
is displayed to 2 decimal places. However the total sum doesn't match the sum of the numbers displayed in the cells. How do I get the sum to equal the displayed amounts in the cell versus the sum of the unrounded cell amounts? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding
Tools/Options/Calculation/check "precision as displayed"
"McGowan" wrote: I am summing cells that are based on the results of a formula and the result is displayed to 2 decimal places. However the total sum doesn't match the sum of the numbers displayed in the cells. How do I get the sum to equal the displayed amounts in the cell versus the sum of the unrounded cell amounts? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding
Check out this link...
http://www.mcgimpsey.com/excel/pennyoff.html -- HTH... Jim Thomlinson "McGowan" wrote: I am summing cells that are based on the results of a formula and the result is displayed to 2 decimal places. However the total sum doesn't match the sum of the numbers displayed in the cells. How do I get the sum to equal the displayed amounts in the cell versus the sum of the unrounded cell amounts? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding
Formatting a cell only changes what is displayed. It doesn't alter the value
in the cell. You should write your individual formulas to round as required: =ROUND(your_formula,2) Or write the SUM formula to do this to each before adding them: =SUM(ROUND(your_range,2)) "McGowan" wrote in message ... I am summing cells that are based on the results of a formula and the result is displayed to 2 decimal places. However the total sum doesn't match the sum of the numbers displayed in the cells. How do I get the sum to equal the displayed amounts in the cell versus the sum of the unrounded cell amounts? Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding
Thanks Bob, I appreciate your Help!
"Bob Umlas, Excel MVP" wrote: Tools/Options/Calculation/check "precision as displayed" "McGowan" wrote: I am summing cells that are based on the results of a formula and the result is displayed to 2 decimal places. However the total sum doesn't match the sum of the numbers displayed in the cells. How do I get the sum to equal the displayed amounts in the cell versus the sum of the unrounded cell amounts? Thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding
Thanks for your reply!
"Jim Thomlinson" wrote: Check out this link... http://www.mcgimpsey.com/excel/pennyoff.html -- HTH... Jim Thomlinson "McGowan" wrote: I am summing cells that are based on the results of a formula and the result is displayed to 2 decimal places. However the total sum doesn't match the sum of the numbers displayed in the cells. How do I get the sum to equal the displayed amounts in the cell versus the sum of the unrounded cell amounts? Thanks |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding
Thanks Stephen!
"Stephen" wrote: Formatting a cell only changes what is displayed. It doesn't alter the value in the cell. You should write your individual formulas to round as required: =ROUND(your_formula,2) Or write the SUM formula to do this to each before adding them: =SUM(ROUND(your_range,2)) "McGowan" wrote in message ... I am summing cells that are based on the results of a formula and the result is displayed to 2 decimal places. However the total sum doesn't match the sum of the numbers displayed in the cells. How do I get the sum to equal the displayed amounts in the cell versus the sum of the unrounded cell amounts? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
Rounding | Excel Worksheet Functions | |||
rounding | Excel Worksheet Functions | |||
Rounding | Excel Worksheet Functions | |||
Rounding | Excel Discussion (Misc queries) |