You can format your values to round the way you want.
Right click on the data field and choose Format Field -> go to Numbers tab - click on Custom button - go to rounding option and select the way you would like to round. That's it!
LB, thank you for the formula. I'm not seeing how your formula will work though. Using 3.4 and 3.8 as examples, and after running through your the formula it comes back to same values.
Where as I would like to see 3.5 and 4.0.... I guess this is called rounding to the nearest .5th value, lol.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.