Timeline for Why does Google Spreadsheets says Zero is not equals Zero?
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 20 at 4:33 | comment | added | Simon East |
@NonlinearFruit - Be very careful when using FLOOR() in Google Sheets as you can occasionally get the wrong result. For example, try this example: =FLOOR(0.3*3-0.9). You would expect the answer to be 0 but it produces -1 because of very tiny floating point arithmetic errors.
|
|
| Jul 28, 2018 at 3:03 | comment | added | NonlinearFruit |
My solution was to =FLOOR(B3+C2, 0.01) for working with currency
|
|
| Jun 17, 2018 at 9:29 | comment | added | Heimdall | There is a platform that uses decimal rather than binary floating point: HP48S. I worked out that the actual decimal digits are stored in packs of 4 bits, so a but wasteful as not all combinations of 4 bits are used. I remember that I experimented by changing the memory directly and even making digits more than 9. | |
| May 23, 2017 at 12:35 | history | edited | CommunityBot |
replaced http://stackoverflow.com/ with https://stackoverflow.com/
|
|
| Nov 28, 2015 at 3:20 | vote | accept | bruno | ||
| Jul 13, 2015 at 18:24 | comment | added | bruno | I mentioned "server-side" because Google could use arbitrary precision decimal numeric type from their favorite programming language within their servers. | |
| Jul 11, 2015 at 2:16 | history | edited | user79865 | CC BY-SA 3.0 |
added 177 characters in body
|
| Jul 11, 2015 at 1:01 | history | answered | user79865 | CC BY-SA 3.0 |