Posted to microsoft.public.excel.worksheet.functions

Frances C[_2_] Frances C[_2_] is offline

external usenet poster

Posts: 31

Formula problem

I have a formula that is simply adding two numbers.

A10 is the total addition of A1:A9 A10= 47,307.55

B10 is the total addition of B1:B9 B10= 139.09

Then when I add A10 + B10 = C10 (C10=47441.63) is off by a penny)

Can you provide me with a formula that can correct this problem?

thanks

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
formula problem	Jonathan	New Users to Excel	3	August 31st 07 10:50 AM
Formula problem	Max	Excel Discussion (Misc queries)	0	August 17th 07 01:50 AM
Help! Formula problem	Rickhotblue	Excel Discussion (Misc queries)	1	February 16th 07 05:06 AM
Formula problem	Mike	Excel Worksheet Functions	2	July 20th 05 02:09 AM
formula problem	Kevin	Excel Discussion (Misc queries)	1	April 13th 05 02:11 PM

All times are GMT +1. The time now is 03:04 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us