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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i set up formula to calculate to the neares 300 number 6
Solver Help 9
Economical grouping of lengths out of much longer lengths 1
LOOKUPS USING 2 SETS OF DATA 5
Formula help 4
Show the formula not the result 3
How do I find a match for three variables to determine the result? 4
Extract given and surname a string 3

Back
Top