Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Rounding Problem
I have got a very simple accounting spreadsheet where column C is
determined by (A+B)*1.06. Cell C is formatted for dollars - two decimal places. At the bottom of column C is a total which is usually correct but sometimes it is out by one cent. All the calculations across are correct. I am sure there is an easy way to fix this isn't there? Thanks. Al |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Rounding Problem
Check this link of John McGimpsey:
http://www.mcgimpsey.com/excel/pennyoff.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Alfred Kaufmann" wrote in message ... I have got a very simple accounting spreadsheet where column C is determined by (A+B)*1.06. Cell C is formatted for dollars - two decimal places. At the bottom of column C is a total which is usually correct but sometimes it is out by one cent. All the calculations across are correct. I am sure there is an easy way to fix this isn't there? Thanks. Al |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Rounding Problem
See
http://www.mcgimpsey.com/excel/pennyoff.html In article , Alfred Kaufmann wrote: I have got a very simple accounting spreadsheet where column C is determined by (A+B)*1.06. Cell C is formatted for dollars - two decimal places. At the bottom of column C is a total which is usually correct but sometimes it is out by one cent. All the calculations across are correct. I am sure there is an easy way to fix this isn't there? Thanks. Al |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Rounding Problem
did you try
=Round((A+B)*1.06,2) will there be no problem in your accounting sheet if you do so? "Alfred Kaufmann" wrote: I have got a very simple accounting spreadsheet where column C is determined by (A+B)*1.06. Cell C is formatted for dollars - two decimal places. At the bottom of column C is a total which is usually correct but sometimes it is out by one cent. All the calculations across are correct. I am sure there is an easy way to fix this isn't there? Thanks. Al |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Rounding Problem
Look at:
http://www.cpearson.com/excel/rounding.htm -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Alfred Kaufmann" wrote in message ... I have got a very simple accounting spreadsheet where column C is determined by (A+B)*1.06. Cell C is formatted for dollars - two decimal places. At the bottom of column C is a total which is usually correct but sometimes it is out by one cent. All the calculations across are correct. I am sure there is an easy way to fix this isn't there? Thanks. Al |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Rounding Problem
you can also try to upgrade your reading within this page.
http://www.microsoft.com/office/comm...xp=&sloc=en-us "Alfred Kaufmann" wrote: I have got a very simple accounting spreadsheet where column C is determined by (A+B)*1.06. Cell C is formatted for dollars - two decimal places. At the bottom of column C is a total which is usually correct but sometimes it is out by one cent. All the calculations across are correct. I am sure there is an easy way to fix this isn't there? Thanks. Al |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Rounding Problem
Thanks everyone, that Round function should solve the problem. I also
discovered in the Excel Options how to set the precision to what is displayed. Just have to ignore that terrible warning that my spreadsheet will lose accuracy. Al I use Excel so often that every time I do Micsoft has a new version ;-( On Mon, 3 Sep 2007 14:16:00 -0700, swordsman wrote: did you try =Round((A+B)*1.06,2) will there be no problem in your accounting sheet if you do so? "Alfred Kaufmann" wrote: I have got a very simple accounting spreadsheet where column C is determined by (A+B)*1.06. Cell C is formatted for dollars - two decimal places. At the bottom of column C is a total which is usually correct but sometimes it is out by one cent. All the calculations across are correct. I am sure there is an easy way to fix this isn't there? Thanks. Al |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Rounding Problem
glad it worked for your accounting sheet!<g
"Alfred Kaufmann" wrote: Thanks everyone, that Round function should solve the problem. I also discovered in the Excel Options how to set the precision to what is displayed. Just have to ignore that terrible warning that my spreadsheet will lose accuracy. Al I use Excel so often that every time I do Micsoft has a new version ;-( On Mon, 3 Sep 2007 14:16:00 -0700, swordsman wrote: did you try =Round((A+B)*1.06,2) will there be no problem in your accounting sheet if you do so? "Alfred Kaufmann" wrote: I have got a very simple accounting spreadsheet where column C is determined by (A+B)*1.06. Cell C is formatted for dollars - two decimal places. At the bottom of column C is a total which is usually correct but sometimes it is out by one cent. All the calculations across are correct. I am sure there is an easy way to fix this isn't there? Thanks. Al |
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Rounding Problem
I would suggest that you NOT use the "Precision as displayed" setting. It
can cause rather odd results in calculations if various cells have a different number of decimal places. You should use ROUND instead. See http://www.cpearson.com/newsletter/c...2007_08_27.htm This article illustrates a rather simple case in which you can have three different values when summing the same numbers. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "Alfred Kaufmann" wrote in message ... Thanks everyone, that Round function should solve the problem. I also discovered in the Excel Options how to set the precision to what is displayed. Just have to ignore that terrible warning that my spreadsheet will lose accuracy. Al I use Excel so often that every time I do Micsoft has a new version ;-( On Mon, 3 Sep 2007 14:16:00 -0700, swordsman wrote: did you try =Round((A+B)*1.06,2) will there be no problem in your accounting sheet if you do so? "Alfred Kaufmann" wrote: I have got a very simple accounting spreadsheet where column C is determined by (A+B)*1.06. Cell C is formatted for dollars - two decimal places. At the bottom of column C is a total which is usually correct but sometimes it is out by one cent. All the calculations across are correct. I am sure there is an easy way to fix this isn't there? Thanks. Al |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rounding Problem | Excel Worksheet Functions | |||
Rounding Problem | Excel Discussion (Misc queries) | |||
Rounding off problem..! | Excel Worksheet Functions | |||
Averaging and Rounding problem | Excel Worksheet Functions | |||
Simple Rounding Problem | Excel Discussion (Misc queries) |