Decimals appearing for no reason
Solved
US17
Posted messages
52
Status
Member
-
US17 Posted messages 52 Status Member -
US17 Posted messages 52 Status Member -
Hello,
With this simple formula, =A1236"Kms since the" that was working well, I obtained:
2788.1 Kms since the
When I moved my reference cell to A2483, (=A2483"Kms since the"),
I ended up with a strange total: 2788.10000000001 Kms since the
I've tried changing the cell format, the number of decimals, nothing works.
Thank you
Configuration: Windows / Firefox 41.0
--
Excel 2013
With this simple formula, =A1236"Kms since the" that was working well, I obtained:
2788.1 Kms since the
When I moved my reference cell to A2483, (=A2483"Kms since the"),
I ended up with a strange total: 2788.10000000001 Kms since the
I've tried changing the cell format, the number of decimals, nothing works.
Thank you
Configuration: Windows / Firefox 41.0
--
Excel 2013
3 answers
-
Hello,
Since you are making a chain, the cell format has no effect.
Round the result:=ROUND(D1,1)&" Kms from the"
eric
By continuously trying, we eventually succeed.
So the more it fails, the more chances we have that it works. (the Shadoks)
In addition to thank you (yes, it’s done!!!), remember to mark it as resolved. Thank you. -
Hello
it's the Excel ghost that wanders from the 11th to the 13th decimal place.
Seriously, this issue seems to be an Excel bug affecting the results of certain calculations, which many people discuss on the forum, but which has never really seen a fix.
That said, it should at least disappear in the display with a format:
number / decimals >2
best regards
--
To err is human, to persist is diabolical. -
Good evening,
yes, those famous floating-point decimals, you will find explanations in this discussion
https://forums.commentcamarche.net/forum/affich-32216517-decimales-capricieuses
--
See you later
Mike-31
A period of failure is a perfect time to sow the seeds of knowledge.
