R
Ronny Andersen
I got an odd problem in Excel.
The problem is that if i take 4.5 (Minus) 4.4, that will result in 0.1
but if i choose 16+ decimals it will go random like this
0,0999999999999996
0,0999999999999997
0,0999999999999999
other combinations also apply too this.
is there a solution too this one?
hope some Excel man can fix this for me as it is a huge problem
The problem is that if i take 4.5 (Minus) 4.4, that will result in 0.1
but if i choose 16+ decimals it will go random like this
0,0999999999999996
0,0999999999999997
0,0999999999999999
other combinations also apply too this.
is there a solution too this one?
hope some Excel man can fix this for me as it is a huge problem