creating if forumula - with drop down menu

[MarianCC]

I am having trouble creating a formula.

I have a drop down menu - each recipient on the menu receives a different commission rate.

I need a calculation in a cell that provides that if person 1 is selected from the drop down menue then the value returned will be their commission rate multiplied bythe value of sales.

=IF(C2=O6, P6*I2, OR(C2=07, P7*I2))

This is wrong, however I have put it in as a sample to try to explain what I am traying to do.

The first IF works. It is only when I begin adding other scenarios that it doesn't.

[rylo]

Hi

How about something like

=I2*OFFSET(P5,MATCH(C2,O6:O7,0),0)

It doesn't cover a situation where there won't be a match between C2 and the data in column O - I'm assuming that the drop down will prevent this.

Another option would be to use VLOOKUP to get the value from column P that references the item in column O.

=I2*VLOOKUP(C2,O6:P7,2,FALSE)

rylo