how do i get a set of pieces from a given # with standard lengths

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sseguine - 18 Dec 2005 07:54 GMT

want to find the number of standard length pieces (47" or 59") from a given
nember in a cell ( example 149 1/2 = 2 @59" and 1 @ 31 1/2") and the length
of the non-standard length piece.

Reply to this Message

Ron Coderre - 18 Dec 2005 13:34 GMT

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-Pro

> want to find the number of standard length pieces (47" or 59") from a given
> nember in a cell ( example 149 1/2 = 2 @59" and 1 @ 31 1/2") and the length
> of the non-standard length piece.

Reply to this Message