Thread: Programming function with 2 conditions to get result

I'm working in Excel 2007 and I have a sheet that has 2 dropdown lists. What I am trying to do is if certain values are picked in the dropdown list it populates a value in a specific cell on the sheet.

for example: in dropdown box 1 the option "TV program" is picked and in dropdown box 2 the option "package A" is picked. As a result the cell populates 37.95.

I was try to use a function with "If Then Else" Statements it only works with one condition. I believe an "AND" statement may work in this situation, but I'm unfamiliar with the syntax.

Any help would be appreciated.

hello, welcome to the forum. give an example workbook, as we have no idea what are you trying to do.