Excel Addition/Formula Help

[Jay R]

When using Excel, it is crucial to remember three things:

1. Computers are inherently stupid. All of your math is now being done by somebody who can only count to one.
2. What it shows you is not what it stores.
3. Any judgment call about how a situation should be handled was made years ago, at MicroSoft, by somebody who didn't know your situation.

You can choose to make the judgment calls, but you must learn how, and then explicitly make them yourself.

In this case, it isn't showing you the number it calculated; it's showing you a 2-digit approximation. But it saved the real number and will calculate it with that.

ROUND() may be the correct tool, but it might not. The company will decide how rounding is done. You may need FLOOR() or CEILING() instead

If you aren't careful, Excel merely allows you to make dumb mistakes much faster and more efficiently.

Excel calculations are no substitute for thought.