Calculating totals of material with feet and inches
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?
|