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

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