round down to 1/16" not up

[nickbs]

Hello, how do I get this string to round down instead of up.

=INT(MROUND(B31,1/192)) & TEXT(12*MOD(MROUND(B31,1/192),1),"' - 0 #/##") & """"

B31 = 10.81

OUTPUT = 10' - 9 3/4"

But I need the out put to be 10 - 9 11/16"

I realize that rounding up is the function of MROUND,, I tried other functions with no luck.

 

[FormR]

Hi, welcome to the forum!

You could try the FLOOR() function - for example:

=INT(FLOOR(B31,1/192)) & TEXT(12*MOD(FLOOR(B31,1/192),1),"' - 0 #/##") & """"

 

[nickbs]

I did try floor, but the result is the same for some reason.

 

[FormR]

I did try floor, but the result is the same for some reason.

With 10.81 in cell B31 I get the result your expecting.. Are you sure the value in B31 is definitely 10.81?

Excel 2013/2016
	B	C
31	10.81	10' - 9 11/16"
Sheet1

Cell Formulas
Range	Formula
C31	=INT(FLOOR(B31,1/192)) & TEXT(12*MOD(FLOOR(B31,1/192),1),"' - 0 #/##") & """"

 

[nickbs]

Ok, now Im scratching my head over here.

b32 c32 e32 g32
[TABLE="width: 731"]
<tbody>[TR]
[TD="class: xl66, width: 111"]Rafter 2[/TD]
[TD="class: xl69, width: 105"]10.81[/TD]
[TD="class: xl65, width: 163"]10' - 9 3/4"[/TD]
[TD="class: xl65, width: 64"][/TD]
[TD="class: xl68, width: 89"]5.45[/TD]
[TD="class: xl65, width: 86"][/TD]
[TD="class: xl67, width: 113"]9.34[/TD]
[/TR]
</tbody>[/TABLE]

b32
=SQRT(SUMSQ(E32,G32))
c32
=INT(FLOOR(B32,1/192)) & TEXT(12*MOD(FLOOR(B32,1/192),1),"' - 0 #/##") & """"

I might need to round down b32 to 10.81

 

[nickbs]

ya that did it

=ROUNDDOWN(SQRT(SUMSQ(E32,G32)),2)

thanks