Login Page - Create Account

Support Board


Date/Time: Fri, 13 Nov 2026 06:03:34 +0000



Post From: Strange spreadsheet output value for tick size J21

[2017-09-26 16:21:33]
Sawtooth - Posts: 4361
Sometimes the value in J21 contains floating point errors.
Use this formula in H21 to remove them:
=1/ROUND(1/J21,0)
Then use this in H15:
=H21=0.0001