Thanks much Toppers & Vito for the answers to my initial question!
Now I've got another 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
"Vito" wrote:
Try:
=E7*0.7*IF(D7="12x",0.8,IF(D7="6x",0.5,0))
--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=538976