Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using some variation of int or trunc
I am using a not-for-profit accounting system called Blackbaud. I am
downloading financial statements from this system using Crystal report format. The reports come into Excel with 2 decimal places. I know that I can format the Excel spreadsheet with 0 decimal places but when I foot and crossfoot a column or row I can have problems with the rounding. For instance I show this on the download Col 1 Col2 Col 3 Total 64043 10617 1049 75710 If you add col 1,2, and 3 as they appear, it totals 75709. This is because the real numbers in these columns are Col1 col2 col3 total 64043.38 10616.88 1049.25 75709.51 I want the total to be 75710. I cant use @ int because I lose values. Can anyone help me with this issue? Thank you in advance for your help. -- aprilshowers |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using some variation of int or trunc
*Don't* format to 0,
*Round* to 0 places. =ROUND(SUM(A1:C1),0) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "april" wrote in message ... I am using a not-for-profit accounting system called Blackbaud. I am downloading financial statements from this system using Crystal report format. The reports come into Excel with 2 decimal places. I know that I can format the Excel spreadsheet with 0 decimal places but when I foot and crossfoot a column or row I can have problems with the rounding. For instance I show this on the download Col 1 Col2 Col 3 Total 64043 10617 1049 75710 If you add col 1,2, and 3 as they appear, it totals 75709. This is because the real numbers in these columns are Col1 col2 col3 total 64043.38 10616.88 1049.25 75709.51 I want the total to be 75710. I can't use @ int because I lose values. Can anyone help me with this issue? Thank you in advance for your help. -- aprilshowers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variation from the mean? | Charts and Charting in Excel | |||
INT ROUND & TRUNC | New Users to Excel | |||
Problem with TRUNC | Excel Worksheet Functions | |||
problems with TRUNC | Excel Discussion (Misc queries) | |||
Trunc | Excel Discussion (Misc queries) |