I set a number entry MAX to a field in my sheet and it will not allow my pilots to log their flights now
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.