View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Krista
 
Posts: n/a
Default Multiple Conditions

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