How come, when I round up decimals some numbers gets wrong
echo round(0.7125, 2);
Will result in: 0.71
BUT:
echo round(0.935625, 2);
Returns: 0.93999999
Why is that?
I´m using: 5.5.45-MariaDB
Asked
Active
Viewed 297 times
-2
-
You pass `0` as number and want it rounded to `935625` place with the mode: `PHP_ROUND_HALF_DOWN` – Rizier123 Sep 08 '15 at 12:01
-
2I hope that you're not specifying numbers with a `comma` as the decimal separator – Mark Baker Sep 08 '15 at 12:03
-
1Shouldn't you use a "." as decimal separator? – Diego Ferri Sep 08 '15 at 12:03
-
PLease remove your "minus". There was actually a dot. Looks like PHPExcell changed it from coma to dot. My problem still remains!!!! – Björn C Sep 08 '15 at 12:15
-
What's PHPExcel got to do with this? You made no mention of that in your original question – Mark Baker Sep 08 '15 at 12:33
-
@MarkBaker no i didnt and it has no point in the question. the only thing i did was to write coma instead of dot. Becuase it´s a dot that goes into rounded! – Björn C Sep 08 '15 at 13:15
2 Answers
3
You are using a comma , instead of a dot . for the decimal separator. Use :
echo round(0.935625, 2); => 0.94
Ok it seems that this is an issue of floating point precision. You are asking the system to display 0.94 which the system can't represent as a float. So it displays the nearest number it can display: 0.93999999
Thomas Ayoub
- 29,063
- 15
- 95
- 142
-
-
@Tomas ok, i think i must read up on float than.. i dont understand. How can i solve this? – Björn C Sep 08 '15 at 12:24
-
@Mjukis I suggest you a bit of reading about [Why Are Floating Point Numbers Inaccurate?](http://stackoverflow.com/q/21895756/2307070) – Thomas Ayoub Sep 08 '15 at 12:27
1
echo round(0.935625, 2); // there is comma instead of .
Please remove comma (,) and try it
Shailesh Katarmal
- 2,757
- 1
- 12
- 15