619
It's just a matter of time
(lemmy.world)
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
this post was submitted on 19 Apr 2026
619 points (100.0% liked)
Facepalm
3617 readers
28 users here now
founded 2 years ago
MODERATORS
I believe the explanation for this is the first cell is formatted as text. And summing text concatenates rather than adds. Then the new value is saved as a number, adding the 3, to get 15.
This is an error that can already happen in Excel and one any experienced Excel user has to look out for when moving between alphanumeric and numeric cell types.
If you used =sum(the fields) wouldn't it ignore any string cells and (in this case if the 1 is "1) return 5? Not that it's any less wrong, of course
so you're saying people who don't know what they're doing shouldn't use tools they don't understand to do things that could cause huge problems if they go wrong? How dare you admonish the Dunning-Kruger field generator!
I'm saying OP's image is an incomplete picture of the problem which blames Copilot for user error.
ByYourLogic, people shouldn't be using Excel to begin with.
In this case, mayhap copilot made the user error. Who knows, probably not the user using copilot to sum numbers in excel.
It's a meme that hinges on the viewer not knowing Excel, not an actual user error in a business environment.