| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating If Then statements from table
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) = |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating If Then statements from table
In case you didn't notice: your post is incomplete
-- Kind regards, Niek Otten Microsoft MVP - Excel "Siper1" wrote in message ... | 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) = | |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating If Then statements from table
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) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Creating If Then statements from table
No need to double-post - you have an answer at your other thread.
Pete On Nov 8, 10:44 pm, Siper1 wrote: 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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shorcuts or Macro for Creating If Else Statements | Excel Worksheet Functions | |||
| Creating summary table from detail table | Excel Worksheet Functions | |||
| 14 Nested IF statements creating different validation lists | Excel Worksheet Functions | |||
| Need to make a mark up table with more than 7 if statements | Excel Worksheet Functions | |||
| Creating my own user defined function help statements | Excel Worksheet Functions | |||
Linear Mode
