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!
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.