Question

E

ebruehling

Is there any way to find out if a particular cell is divisible by 48
(i.e 4 ft)?
 
B

Bernard Liengme

=mod(A1,48) returns the remainder when the value in A1 is divided by 48;
gives zero if exactly divisible.
=IF(mod(A1,48),"Not divisible",")
best wishes
 
B

Brumeister

dribler2 said:
i maybe confused here but try this...

maybe u mean if 48 is divisible by which divisor <integer e.g. 4>...without
a remainder...

A1=number (divisor)

on B1
=mod(48,A1)=0

returns True if divisible or false if not divisible <no remainder>
Click to expand...

Thank you all for replying... much appreiciated. I am going to share
what I am working on... Dont know why I am doing this but I started it
and now I want to finish it... I work in a sheet metal fabrication
facility and what I want to do is make an easy (which I thought) spread
sheet to calculate how many sheets of material (typically 48 wide
material) I am going to use and any drop piece I might have. If things
are divisible into 48, everything works great, but if I have a width of
lets say 18.75 thats when things get screwed up a bit... on a width of
18.75" I am going to get 2 cuts per sheet and drop of 10.5in. If I
type in 9 pcs @ 18.75", 120 length, I should get 2 per sheet and use 5
sheets and a drop pc of 29.25". If you can understand this great, if
not well I will keep plugging along... I have learned alot already from
trial and error so I am winning either way. :)

example of what I am trying to achieve.

PIECES WIDTH LENGTH #FOOT sheets used per sheet drop pc.
6 8 in. 120 in. 40 1 6 0
9 18.75 120 140.63 5 2 29.2
1 25 120 20.83 1 1 23
 
C

CLR

In A1 put 18.75...the cut size
In B1 put 48........the sheet size
IN C1 put =INT(B1/A1)......yield of whole pieces
In D1 put =(B1/A1-C1)*A1...remaining drop size

hth
Vaya con Dios,
Chuck, CABGx3
 
Top