Excel thinks 7 + 7 + 3 = 18...what gives?

Thread Rating:

0 Vote(s) - 0 Average
1
2
3
4
5

Linear Mode

Excel thinks 7 + 7 + 3 = 18...what gives?

N-OS X-tasy! Offline

Offline

Unregistered

Posts: 28,821
Threads: 209
Joined: May 2025

#3

12-05-2009, 05:19 AM

OK, seriously...

The sum value of the third decimal place is causing the total to round up. Currency formatting doesn't change a number entered in a cell - it simply formats it to display with a dollar sign and to two decimal places.

Find

Reply

« Next Oldest | Next Newest »

Messages In This Thread

Excel thinks 7 + 7 + 3 = 18...what gives? - by StingMe - 12-05-2009, 05:08 AM

Re: Excel thinks 7 + 7 + 3 = 18...what gives? - by N-OS X-tasy! - 12-05-2009, 05:17 AM

Re: Excel thinks 7 + 7 + 3 = 18...what gives? - by N-OS X-tasy! - 12-05-2009, 05:19 AM

Re: Excel thinks 7 + 7 + 3 = 18...what gives? - by Dick Moore - 12-05-2009, 05:19 AM

Re: Excel thinks 7 + 7 + 3 = 18...what gives? - by Winston - 12-05-2009, 05:33 AM

Re: Excel thinks 7 + 7 + 3 = 18...what gives? - by StingMe - 12-05-2009, 05:36 AM

Re: Excel thinks 7 + 7 + 3 = 18...what gives? - by Gareth - 12-05-2009, 06:14 AM

Re: Excel thinks 7 + 7 + 3 = 18...what gives? - by NewtonMP2100 - 12-05-2009, 06:24 AM

Re: Excel thinks 7 + 7 + 3 = 18...what gives? - by MGS_forgot_password - 12-05-2009, 04:20 PM

Re: Excel thinks 7 + 7 + 3 = 18...what gives? - by Jimmypoo - 12-05-2009, 04:47 PM

Re: Excel thinks 7 + 7 + 3 = 18...what gives? - by Buck - 12-05-2009, 06:56 PM

View a Printable Version

Users browsing this thread: 1 Guest(s)