Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What formula do I use for this?
I have a formula that performs a calculation to determine cubic lbs/sq foot
of a shipment of materials. (Please see below.) The table underneath the calculation shows me under which shipweight classification the shipment falls. I would like the form to automatically tell me what the shipweight classification is by looking at the range that the cubic/lbs per sq. foot falls in, and pulling the classification number from the table. Does anyone have any suggestions? I am stuck... Thanks in advance, Jen SHIPWEIGHT CLASS CALCULATOR L x W xH = 0.00 0/1728 =0.00 (lbs/cubic foot) Pounds per Cubic Foot Classification 50 50 35 55 30 60 22.5 65 15 70 13.5 77.5 12 85 10.5 92.5 9 100 8 110 7 125 6 150 5 175 4 200 3 250 2 300 1 400 < 1 500 -- J. Shafer AWP Industries, Inc. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What formula do I use for this?
Have a look at VLOOKUP
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "jenatawp" wrote in message ... I have a formula that performs a calculation to determine cubic lbs/sq foot of a shipment of materials. (Please see below.) The table underneath the calculation shows me under which shipweight classification the shipment falls. I would like the form to automatically tell me what the shipweight classification is by looking at the range that the cubic/lbs per sq. foot falls in, and pulling the classification number from the table. Does anyone have any suggestions? I am stuck... Thanks in advance, Jen SHIPWEIGHT CLASS CALCULATOR L x W xH = 0.00 0/1728 =0.00 (lbs/cubic foot) Pounds per Cubic Foot Classification 50 50 35 55 30 60 22.5 65 15 70 13.5 77.5 12 85 10.5 92.5 9 100 8 110 7 125 6 150 5 175 4 200 3 250 2 300 1 400 < 1 500 -- J. Shafer AWP Industries, Inc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|