Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Statement with many variables
I've got scenario with multiple variables
Column A: I could have one of 6 options from a drop-down list Column B: I could have one of 4 options from a drop-down list Column C: I need to put in some kind of conditional statment that says if Column A = "Full Page" and Column B = "1x" then input $10,000 etc As you can see there are a total of 24 variables each with a different input amount for Column C. Can anyone let me know what the best way to do this would be? Is it possible to set up a table on another worksheet then reference that table in Column C??? Thanks! -- Krista |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Statement with many variables
Consider 1) creating a data table; then 2) using a vlookup function in the
table; Your mileage may vary "Krista" wrote: I've got scenario with multiple variables Column A: I could have one of 6 options from a drop-down list Column B: I could have one of 4 options from a drop-down list Column C: I need to put in some kind of conditional statment that says if Column A = "Full Page" and Column B = "1x" then input $10,000 etc As you can see there are a total of 24 variables each with a different input amount for Column C. Can anyone let me know what the best way to do this would be? Is it possible to set up a table on another worksheet then reference that table in Column C??? Thanks! -- Krista |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Statement with many variables
Krista,
have just responded to your earlier thread. Pete |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Statement with many variables
Thanks Headly and Pete for the help!
-- Krista "Pete_UK" wrote: Krista, have just responded to your earlier thread. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formating on if statement | Excel Worksheet Functions | |||
How do I use a conditional (IF) statement in Data Validation? | Excel Worksheet Functions | |||
conditional statement | New Users to Excel | |||
How can I use HYPERLINK in a conditional statement between sheets | Excel Worksheet Functions | |||
Conditional Statement with ANDs | Excel Discussion (Misc queries) |