Formulas with if functions????

[Guest]

Hi

I have a data base that looks like:

"Tonnage U Of M "Cargo
Tonnage
NT"
15,514.00 GROSS
15,893.00 GROSS
13,242.91 METRIC
15,609.00 GROSS
16,035.00 NET_TONS
15,587.00 GROSS
10,431.00 METRIC
500 NET_TONS
14,039.00 METRIC


In the Cargo Tonnage Column, I want it to be in net tonnes.

So if it says GROSS in the 2nd column, it needs to take the first column and
muliply it by 1.12, if it say METRIC, it needs to multiply by 1.1024 and
NET_TONS, stays the same.

How is this done?

-

 

[Bob Phillips]

=A2*(INDEX({1.12,1.024,1},MATCH(B2,{"GROSS","METRIC","NET_TONS"},0)))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[PCLIVE]

Possibly one way:

=IF(B2="GROSS",A2*1.12,IF(B2="METRIC",A1*1.1024,A2))

HTH,
Paul

 

[Guest]

I tried both ways, and they both worked -- thank-you!