I'm setting up a spread sheet for bill of materials. Let's say I have
3x3x1/4 material at 1' 10 3/8" each and 3x3x1/4 at 5' 4 1/8" each. I want
Excel to calculate total in feet and inches. Bascially variable sizes.

I am not sure how to write this so that I can use it for other materials. I
need to find out the total of the material to order. Is there any easy way to
do this?

Assuming you are trying to get at (1) how many sheets of 3x3x1/4 are in a 1'
10 3/8" stack, (2) how many sheets of 3x3x1/4 are in a 5' 4 1/8" stack...
=[(1x12)+10+(3/8)]/.25 = 89.5 sheets
and
=[(5*12)+4+(1/4)]/.25 = 256.5 sheets
Not sure how you could get half a sheet like that but, mathematically, that
is the answer.
--
Hope this helps.
If this post was helpfull, please remember to click on the ''''YES''''
button at the bottom of the screen.
Thanks,
Gary Brown


"Julleanna" wrote:

I'm setting up a spread sheet for bill of materials. Let's say I have
3x3x1/4 material at 1' 10 3/8" each and 3x3x1/4 at 5' 4 1/8" each. I want
Excel to calculate total in feet and inches. Bascially variable sizes.

I am not sure how to write this so that I can use it for other materials. I
need to find out the total of the material to order. Is there any easy way to
do this?