close
want to find the number of standard length pieces (47quot; or 59quot;) from a given
nember in a cell ( example 149 1/2 = 2 @59quot; and 1 @ 31 1/2quot;) and the length
of the non-standard length piece.
Try this:
B1: 59
C1: 47
D1: NonStandard
A2: 149.5
B2: =INT(A2/59)
C2: =INT(MOD(A2,59)/47)
D2: =MOD(MOD(A2,59),47)
Those formulas return:
B2: 2
C2: 0
D2: 31.5
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Proquot;sseguinequot; wrote:
gt; want to find the number of standard length pieces (47quot; or 59quot;) from a given
gt; nember in a cell ( example 149 1/2 = 2 @59quot; and 1 @ 31 1/2quot;) and the length
gt; of the non-standard length piece.
全站熱搜
留言列表
