Conditional Statement with many variables

Giganews Newsgroups
Subject: Conditional Statement with many variables
Posted by:  Krista
Date: Mon, 8 May 2006

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

Replies