Glide Math

I set a number entry MAX to a field in my sheet and it will not allow my pilots to log their flights now :frowning:

Screen Shot 2021-01-26 at 12.40.26 PM
Screen Shot 2021-01-26 at 12.41.15 PM
Screen Shot 2021-01-26 at 12.40.15 PM

Are you using precision to round, or are you using a ROUND() function in the formula?

Precision

Can your value go out to 4 decimal places, or is it always 1 decimal place, but displayed as 4? If it’s only 1 decimal place, then try multiplying by 10, rounding it, then divide by 10.

ROUND(X*10)/10

If it can be out to 4 decimal places, then just replace 10 with 10000.

3 Likes