Formulas with if functions????
 

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?

-
:)

Formulas with if functions????
 

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

--
---
HTH

Bob

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



"Ruth" wrote in message
...
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?

-
:)

Formulas with if functions????
 

Possibly one way:

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

HTH,
Paul


"Ruth" wrote in message
...
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?

-
:)

Formulas with if functions????
 

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


"PCLIVE" wrote:

Possibly one way:

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

HTH,
Paul


"Ruth" wrote in message
...
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?

-
:)