Posted to microsoft.public.excel.misc

ETC

external usenet poster

Posts: 3

Excel returning an incorrect total

When I add -2.1-0.2+2.8-0.5 which should = 0, excel returns -4.44089E-16. I
have tried this on two different spreadsheets, entering the exact values.

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
year formula returning incorrect value	dbdewitt	Excel Worksheet Functions	6	April 3rd 23 01:13 PM
Incorrect Total in Excel 2007	Dana F. Brewer	Excel Worksheet Functions	3	November 20th 09 03:49 PM
Cell reference returning incorrect value	JohnOC	Excel Discussion (Misc queries)	2	April 9th 09 02:29 PM
Lookup returning incorrect value	Sherry	Excel Discussion (Misc queries)	3	January 29th 08 07:57 PM
SUMPRODUCT returning incorrect result	sahafi	Excel Worksheet Functions	7	September 22nd 06 11:36 PM

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

About Us

"It's about Microsoft Excel"