Anyone using Google Drive spreadsheet ever caught a math error?

[def90]

Currency by default rounds up to the nearest penny, so my guess would still be rounding - for example:

If you took 43% of $97.37, the formula is 97.37 * .43 you would get 41.8691, but in a currency column, that would display as $41.87. However under that display is still 41.8691, and that is what is used in subsequent formulas.
Without seeing actual numbers, it's hard for me to say if that is what is happening to you, but that seems what is most likely to me.

One way you can check is to change the formatting of all the currency columns or rows to numbers.

Hope that helps.

This.. it displays the result as a rounded number but the original number remains behind the scenes to be used in any additional formulas.

[Irving]

Wouldn't it be one cent short in that situation though, instead of one cent over?

[mackbamf]

If you are dealing with formulas then this is just a rounding issue. If the column is adding hard numbers that you are entering to a couple of decimal places and it isn't adding up then that would be a separate issue. I have to deal with large spreadsheets at times and these type of rounding issues are not uncommon with formulas.

[Irving]

I've been doing this for years, and this is the first time I've noticed a discrepancy that I couldn't explain. So one cent in years is pretty good. If it makes a difference it's a currency column, times a percentage. So everything is actually in currency format. I'm just glad to know that it's not abnormal and I can still trust my spread sheet.

[CS1983]

Google spreadsheets was a forked project written by Peter Gibbons, Michael Bolton, and Samir Nagheenanajar after they lost their previous jobs working together at a dot com bubble tech company. This might explain the issues you are seeing.

[Irving]

At the end of the year, I'll just slip a check for one cent into an envelope and slide it under the door at the IRS.

[Gman]

Google spreadsheets was a forked project written by Peter Gibbons, Michael Bolton, and Samir Nagheenanajar after they lost their previous jobs working together at a dot com bubble tech company. This might explain the issues you are seeing.

Oh, an Initech company.

[thedave1164]

make sure the formulas are being applied against values, not other formulas.

that is my best guess, I have a spreadsheed sheet at work that combines a lot of formulas in one sheet and we have to be careful that we are using actual values or it goes all awry

[Jeffrey Lebowski]

Google spreadsheets was a forked project written by Peter Gibbons, Michael Bolton, and Samir Nagheenanajar after they lost their previous jobs working together at a dot com bubble tech company. This might explain the issues you are seeing.

lol, bravo

[Jer]

Google spreadsheets was a forked project written by Peter Gibbons, Michael Bolton, and Samir Nagheenanajar after they lost their previous jobs working together at a dot com bubble tech company. This might explain the issues you are seeing.

I was thinking this same thing as I was reading through the thread. Well played sir.