Excel Quirks | Why Calculation Results Can Be Off Due to the Accumulation of Fractional Values

Hello, everyone.

This is Enta.

The other night, my seniors invited me out for drinks.

At that time, I ordered tomato pasta for delivery lol

The party was over, so I went home and went to bed, but I had a stomachache...

My stomach really has gotten weaker, hasn't it?

On top of that, the year-end party season is just around the corner.

I can't live without Ota-I-San, lol.

Ota-I-San


But that's beside the point.

Do you know about Excel's quirks?Excel

It's just that I have a habit of doing the math, lol.

It goes without saying, lol

 

If you let Excel do the calculations, you'll get the answer.

 

It's actually pretty hard to come up with an example, but,

When you use a calculated answer to find another answer,

If possible, it's important to convert it back to an integer.

Truncating the decimal places, rounding to the second decimal place, and so on

If you don't round off the fractions, they'll just keep adding up.

 

The accumulated fractions result in an answer different from that obtained by hand.

Let's be careful.

 

Well, that's it for now.

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.