Forum Discussion
Marshall1210
Jul 27, 2023Copper Contributor
Round decimal to nearest 1/3
I have a formula that gives me decimals (33.439) I need the Tenth decimal to round up to the nearest 3rd (33.666) 1.0 1.333 1.666 2.0 Thank you for any help I can get on this!
- Jul 27, 2023
Cfivins
Jul 27, 2023Copper Contributor
Will something like this work for you?
=int(x*3+.999)/3
Marshall1210
Jul 27, 2023Copper Contributor
This worked as well thank you so much