Jun 29 2019 11:45 AM
Jun 29 2019 01:17 PM - edited Jun 29 2019 01:21 PM
SolutionThat's since 20.15-20 actually is equal to
0.14999999999999900 |
The workaround is
=ROUND(B1,1)-ROUND(A1,1)
Aug 21 2019 01:36 PM - edited Aug 21 2019 01:37 PM
I also can confirm that the actual # is 0.149 which rounds down and needs to have a "round" function added. Please mark the first comment with this answer as correct! @Neelakandan2408
-Aron
Jun 29 2019 01:17 PM - edited Jun 29 2019 01:21 PM
SolutionThat's since 20.15-20 actually is equal to
0.14999999999999900 |
The workaround is
=ROUND(B1,1)-ROUND(A1,1)