What formula do I use for this?

G

Guest

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

Ad

B

Bernard Liengme

Have a look at VLOOKUP
best wishes

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.