Forum Discussion
Solved
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!
6 Replies
Marshall1210 Try this formula. Download the attached file.
=INT(A1)+XLOOKUP(MOD(A1,1),{0.333,0.666,1},{0.333,0.666,1},,1)- This is exactly what I needed This formula is perfect. Thanks to all before this one but this is best response.
Will something like this work for you?
=int(x*3+.999)/3
- This worked as well thank you so much
- Thank you it worked
