Excel addition bug?

Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > Excel addition bug?

SirViver: Oct 22, 2008

Shroud posted:

Yes - I have the cells format set to "accounting".

Setting a cell format does not round the underlying values. All the accounting format does is show the content rounded to two decimal places and the currency symbol on the left. You can enter 1.235 and Excel will display it as 1.24, but the actual value stored in the cell is still 1.235. If you then sum multiple cells like this Excel will calculate the most accurate result it can using the actual non-rounded/non-display-formatted values.

If you need to get the sum of the rounded values (because for example in reality you can't pay someone half a cent), then adjust your formula like so:
SUM(ROUND(B3:B7, 2))

# ¿ Aug 1, 2015 16:24

Adbot: ADBOT LOVES YOU

# ¿ Apr 25, 2024 13:08

The Something Awful Forums > Discussion > Serious Hardware/Software Crap > Excel addition bug?