Re:How many floating-point numbers are in the interval [0,1]?
by mirimir on Wednesday March 01, 2017 @08:36PM
(#13770630)
For binning data in spreadsheets for histograms etc, I typically use text() to set significant digits, and then value(). It's also good sometimes to make sure that 0 is really 0.
To put it another way...it's about significant digits. A float has about 7 and a double about 15. It does not matter whether you use 0 to 360 or 0 to 3.6 million...the number of digits that are meaningful remain the same.