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.
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.
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
"sseguine" wrote:
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks