Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum is not correct after adding calculated fields
I have probably 60 rows that have percentage calculations to come up with a
dollar figure. When I then take all those numbers and add them to see total dollars, I have found that the bottom line is not correct. I routine run another column, manually adding the dollars for each cell as a double check. How can I make sure my totals are correct without having to manually add them. How to I make the sum take the end dollar amount and not be looking at the calculation anymore? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum is not correct after adding calculated fields
In Excel 2003 go to Tools-Options and check the box 'Precision as displayed'
Pl. make sure that you do not have calculations which might be impacted by losing precision... "Laryn" wrote: I have probably 60 rows that have percentage calculations to come up with a dollar figure. When I then take all those numbers and add them to see total dollars, I have found that the bottom line is not correct. I routine run another column, manually adding the dollars for each cell as a double check. How can I make sure my totals are correct without having to manually add them. How to I make the sum take the end dollar amount and not be looking at the calculation anymore? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum is not correct after adding calculated fields
Laryn
The downside of this option (Tools Options Calculation Precision as displayed) is that it affects the calculations of all cells in the spreadsheet. That may or may not be what you want. If this post helps click Yes --------------- Jacob Skaria "Laryn" wrote: I have probably 60 rows that have percentage calculations to come up with a dollar figure. When I then take all those numbers and add them to see total dollars, I have found that the bottom line is not correct. I routine run another column, manually adding the dollars for each cell as a double check. How can I make sure my totals are correct without having to manually add them. How to I make the sum take the end dollar amount and not be looking at the calculation anymore? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum is not correct after adding calculated fields
Okay, so if this could affect the calculations - is there anything else I can
do? "Jacob Skaria" wrote: Laryn The downside of this option (Tools Options Calculation Precision as displayed) is that it affects the calculations of all cells in the spreadsheet. That may or may not be what you want. If this post helps click Yes --------------- Jacob Skaria "Laryn" wrote: I have probably 60 rows that have percentage calculations to come up with a dollar figure. When I then take all those numbers and add them to see total dollars, I have found that the bottom line is not correct. I routine run another column, manually adding the dollars for each cell as a double check. How can I make sure my totals are correct without having to manually add them. How to I make the sum take the end dollar amount and not be looking at the calculation anymore? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum is not correct after adding calculated fields
Have aread here at John McGimpsey's site.
http://www.mcgimpsey.com/excel/pennyoff.html Bottom line............... Unfortunately, there's no hard and fast rule for how to deal with this problem. The key is to be aware that it exists, and to design your workflow to handle the error in an appropriate way. Gord Dibben MS Excel MVP On Thu, 25 Jun 2009 06:06:01 -0700, Laryn wrote: Okay, so if this could affect the calculations - is there anything else I can do? "Jacob Skaria" wrote: Laryn The downside of this option (Tools Options Calculation Precision as displayed) is that it affects the calculations of all cells in the spreadsheet. That may or may not be what you want. If this post helps click Yes --------------- Jacob Skaria "Laryn" wrote: I have probably 60 rows that have percentage calculations to come up with a dollar figure. When I then take all those numbers and add them to see total dollars, I have found that the bottom line is not correct. I routine run another column, manually adding the dollars for each cell as a double check. How can I make sure my totals are correct without having to manually add them. How to I make the sum take the end dollar amount and not be looking at the calculation anymore? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated fields in Records | Excel Discussion (Misc queries) | |||
Problem with Calculated Items on Calculated Fields. | Excel Worksheet Functions | |||
How do I get correct results when LOOKUP with calculated numbers | Excel Worksheet Functions | |||
Calculated fields | Excel Discussion (Misc queries) | |||
pivottable calculated fields | Excel Discussion (Misc queries) |