I'm going fucking insane please help me.
I'm trying to figure out how to make a number round in a very specific way in the sheet.
I have a decimal number, I want it as whole number with the remainder rounded to the closest of the following fractions, and displayed as such
3/4
2/3
5/8
1/2
3/8
1/3
1/4
1/8
So 1.80 would round to 1 3/4
1.95 to 2
5.56 to 51/2
ect...
Is this even possible? I've manage to get everything to round to ( N x/8) through the formatting as "# ?/8" but thats as close as I've come.
I'm trying to figure out how to make a number round in a very specific way in the sheet.
I have a decimal number, I want it as whole number with the remainder rounded to the closest of the following fractions, and displayed as such
3/4
2/3
5/8
1/2
3/8
1/3
1/4
1/8
So 1.80 would round to 1 3/4
1.95 to 2
5.56 to 51/2
ect...
Is this even possible? I've manage to get everything to round to ( N x/8) through the formatting as "# ?/8" but thats as close as I've come.