Posted to microsoft.public.excel.misc

external usenet poster

Posts: 29

problem with Summation

Guys

I have come across this problem a number of time. C1 to C7 are all 2 decimal
placed numbers but the summation (=sum(C1:C7) of all of them come out as
332,069.1800000010000. What can i do about this?

Expenses $
C1 6,055,337.25
C2 (611,570.68)
C3 0.00
C4 (5,259,682.31)
C5 1,119.12
C6 146,826.12
C7 39.68
Manual Sum 332,069.1800000010000
Cosolidated 332,069.18
Diff 0.0000000006985

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Summation	[email protected]	Excel Discussion (Misc queries)	2	November 28th 07 05:12 PM
summation	ExcelQuestion	Excel Worksheet Functions	11	June 27th 07 02:28 AM
Summation problem with Range	jesmin	Excel Discussion (Misc queries)	2	March 15th 06 11:27 PM
Summation from a to b	jeblunk	Excel Worksheet Functions	3	December 4th 05 02:14 PM
Summation Problem	cdehrlich	Excel Worksheet Functions	2	November 8th 04 05:54 PM

All times are GMT +1. The time now is 02:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us