View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary Brown[_4_] Gary Brown[_4_] is offline
external usenet poster
 
Posts: 209
Default 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?