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

S

sseguine

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.
 
R

Ron Coderre

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
 
Top