this post was submitted on 06 Jul 2025
1026 points (98.6% liked)

Greentext

6653 readers
2059 users here now

This is a place to share greentexts and witness the confounding life of Anon. If you're new to the Greentext community, think of it as a sort of zoo with Anon as the main attraction.

Be warned:

If you find yourself getting angry (or god forbid, agreeing) with something Anon has said, you might be doing it wrong.

founded 2 years ago
MODERATORS
 
you are viewing a single comment's thread
view the rest of the comments
[–] Blackmist@feddit.uk 67 points 16 hours ago (5 children)

We had computer classes where we had to learn about spreadsheets.

To do a number plus ten percent we had to put in A1+A1*10/100

I did A1*1.1 like a normal person.

She then went round to make sure everyone had put it in correctly. Got annoyed at me and changed A1 to something else to expose my folly.

Was visibly annoyed when it showed the right answer.

[–] needanke@feddit.org 12 points 16 hours ago* (last edited 15 hours ago) (4 children)

(I don't think that was your teachers point at all, but) couldn't the different formulas have produced different rounding errors due to floating point percision?

[–] funkless_eck@sh.itjust.works 15 points 15 hours ago (1 children)

Excel has a 15 point float, a quadrillionth, which should be enough for anything you were using excel for.

yeah because excel does rounding stuff automatically for you

try entering 0.1 + 0.2 - 0.1 - 0.2 == 0.0 in any programming language of your choice and see what happens.

load more comments (2 replies)
load more comments (2 replies)