Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default My accounting program is a penny off, Why?

I am running a basic account program I set up my self. I use this program to
keep track of my monthly expenses, what I spend money on, how much I spend,
to incluld taxes. One collum I keep track of my yearly expenses, the other I
keep track of my monthly expenses.
My yearly is correct to the penny, but my monthly is a penny off. I use an
Canon palm printer PZ-D to add everything up. All numbers are correct. Except
the monthly collum. The collum names are (cu) & (cv) I have try everly thing
I know but nothing works.
You may not think a penny is much but I do.
Is there somebody out there who can help me with this probem.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 461
Default My accounting program is a penny off, Why?

Try extending the Decimal points out to 4 or 5 places... then subtract the
monthly column # from the Yearly column number. Then sort them by the highest
value. It's most likely a small rounding error.

"bigelwood" wrote:

I am running a basic account program I set up my self. I use this program to
keep track of my monthly expenses, what I spend money on, how much I spend,
to incluld taxes. One collum I keep track of my yearly expenses, the other I
keep track of my monthly expenses.
My yearly is correct to the penny, but my monthly is a penny off. I use an
Canon palm printer PZ-D to add everything up. All numbers are correct. Except
the monthly collum. The collum names are (cu) & (cv) I have try everly thing
I know but nothing works.
You may not think a penny is much but I do.
Is there somebody out there who can help me with this probem.

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,572
Default My accounting program is a penny off, Why?

Check out this page of J.E. McGimpsey:

http://www.mcgimpsey.com/excel/pennyoff.html

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"bigelwood" wrote in message
...
I am running a basic account program I set up my self. I use this program

to
keep track of my monthly expenses, what I spend money on, how much I

spend,
to incluld taxes. One collum I keep track of my yearly expenses, the other

I
keep track of my monthly expenses.
My yearly is correct to the penny, but my monthly is a penny off. I use an
Canon palm printer PZ-D to add everything up. All numbers are correct.

Except
the monthly collum. The collum names are (cu) & (cv) I have try everly

thing
I know but nothing works.
You may not think a penny is much but I do.
Is there somebody out there who can help me with this probem.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ACCOUNTING SERVICES CENTROL BUSINESS Excel Discussion (Misc queries) 1 January 15th 07 05:46 AM
Accounting report nc Excel Discussion (Misc queries) 5 November 28th 06 03:16 PM
easy accounting program in excel? mandycheryl Setting up and Configuration of Excel 1 May 26th 06 08:19 PM
how do i do an accounting spreadsheet how do i do an accounting spreadsheet Excel Worksheet Functions 2 November 19th 05 05:24 PM
In Excel the total is off by a penny. jules Excel Worksheet Functions 1 June 17th 05 03:43 AM


All times are GMT +1. The time now is 03:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"