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

=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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

wrote in message
ups.com...
Is there any way to find out if a particular cell is divisible by 48
(i.e 4 ft)?

Maybe this will help...........

=IF((A1*12)/48-INT((A1*12)/48)=0,"Yes","No")

Vaya con Dios,
Chuck, CABGx3



" wrote:

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

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

--
*****
birds of the same feather flock together..



" wrote:

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

dribler2 wrote:
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

--
*****
birds of the same feather flock together..



" wrote:

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



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

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



"Brumeister" wrote in message
oups.com...
dribler2 wrote:
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

--
*****
birds of the same feather flock together..



" wrote:

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



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

Brumeister,

try to learn solver and goal seek tools in excel...if bare material economy
is your reason for doing this calculation...
Bare quantity of material that you order for your fabrication must include
also other factors (besides waste calculated in your sheet).
try to browse through http://www.solver.com/exceluse.htm..., i think i have
seen one sample problem exactly the same as yours....

good luck
--
*****
birds of the same feather flock together..



"Brumeister" wrote:

dribler2 wrote:
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

--
*****
birds of the same feather flock together..



" wrote:

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



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

If you are doing a lot of this cutting try this neat little program.

http://cutlistplus.com/?wo

Download a free trial. Note the LT version allows 25 parts per project.


Gord Dibben MS Excel MVP

On 10 Jan 2007 17:04:08 -0800, "Brumeister" wrote:

dribler2 wrote:
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

--
*****
birds of the same feather flock together..



" wrote:

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



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