Forum Discussion

Copper Contributor

Jul 27, 2023

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!

Formulas and Functions

Riny_van_Eekelen
Jul 27, 2023
Marshall1210 Perhaps this?
=MROUND(A1,1/3)
where A1 contains the number you need to round.

Riny_van_Eekelen

Platinum Contributor

Jul 27, 2023

Marshall1210 Perhaps this?

=MROUND(A1,1/3)

where A1 contains the number you need to round.

Marshall1210
Copper Contributor
Jul 27, 2023
Thank you it worked