Creating If Then statements from table

[Siper1]

I'm trying to create and If/then statement from the following table:

I have a drop down list with the values on x
I have a drop down list with the values on y
I need to populate another field with the value that corresponds to the
combination of the two.

How do I do that?

Here's the data:

1 M 10 M 20 M 30 M
1.3 Mbps 877,500 8,775,000 17,550,000 26,330,000
1.7 Mbps 1,147,500 11,475,000 22,950,000 34,425,000
2.5 Mbps 1,687,500 16,875,000 33,750,000 50,625,000

Also

Help with:

If (X) = 1.3 mbps then (A*.878), If = 1.7 Mbps then (a*1.147), if 2.5 mbps
then (a*1.687)

if (x) =

 

[Niek Otten]

In case you didn't notice: your post is incomplete

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| I'm trying to create and If/then statement from the following table:
|
| I have a drop down list with the values on x
| I have a drop down list with the values on y
| I need to populate another field with the value that corresponds to the
| combination of the two.
|
| How do I do that?
|
| Here's the data:
|
| 1 M 10 M 20 M 30 M
| 1.3 Mbps 877,500 8,775,000 17,550,000 26,330,000
| 1.7 Mbps 1,147,500 11,475,000 22,950,000 34,425,000
| 2.5 Mbps 1,687,500 16,875,000 33,750,000 50,625,000
|
| Also
|
| Help with:
|
| If (X) = 1.3 mbps then (A*.878), If = 1.7 Mbps then (a*1.147), if 2.5 mbps
| then (a*1.687)
|
| if (x) =
|

 

[Siper1]

This is correct now ....

I'm trying to create and If/then statement from the following table:

I have a drop down list with the values on x
I have a drop down list with the values on y
I need to populate another field with the value that corresponds to the
combination of the two.

How do I do that?

Here's the data:

1 M 10 M 20 M 30 M
1.3 Mbps 877,500 8,775,000 17,550,000 26,330,000
1.7 Mbps 1,147,500 11,475,000 22,950,000 34,425,000
2.5 Mbps 1,687,500 16,875,000 33,750,000 50,625,000

Also

Help with:

If (X) = 1.3 mbps then (A*.878), If = 1.7 Mbps then (a*1.147), if 2.5 mbps
then (a*1.687)

 

[Pete_UK]

No need to double-post - you have an answer at your other thread.

Pete