LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Location: New York
Posts: 2
Default Sum Function has small remainder

HI.

I am using the sum function to add three numbers that I know add to zero. I have typed these numbers in using the keyboard and none of these numbers have more than two decimal places. The numbers are

9,375.73
(9,362.27)
(13.46)

The answer given by the sum function is (0.00000000000087396756498492300000)

I am formatting all these numbers as comma style. In comma style all true zeros show up as "-" and all numbers between (.005) and .005 exclusively are displayed as "(0.00)" This causes inconsistencies in how zeros are displayed in my report.

I am using Excel 2003 on Windows 7

Thank you for your help

Michael
 
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
How to use small function? Eric Excel Discussion (Misc queries) 10 July 16th 07 01:28 PM
Small Function Shankidi Excel Worksheet Functions 4 February 19th 07 11:36 PM
Sum does not sum to zero - leaves very small remainder Michael Excel Discussion (Misc queries) 3 October 10th 06 05:26 AM
SMALL function if 0 Louis Excel Worksheet Functions 5 September 29th 06 06:46 PM
Remainder Zero Function? JudithJubilee Excel Worksheet Functions 3 November 9th 04 01:16 PM


All times are GMT +1. The time now is 08:31 PM.

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"