Multiply Value from the drop down to a specific cell

Hi guys,

just need your help with the attached spreadsheet. Just basically need to multiply the specific value from a drop down list to a specific cell. Please refer to the attached file to view the sheet im working on.

Many thanks in advance.

Regards

Great help! Many thanks

Originally Posted by Ace_XL

Try this in Col E

=IF(C7=1,H16,D16)*INDEX($Y$2:$Y$8,C7)

Hi Ace

Just a follow up question, hope u can help me, the formula below works but just need to modify. for C7, it should be 1 and 2. Coz I added another option in the drop down menu, how should I go about it? Thanks again for the help

=IF(C7=1,H16,D16)*INDEX($Y$2:$Y$8,C7)

Originally Posted by Ace_XL

Try this in Col E

=IF(C7=1,H16,D16)*INDEX($Y$2:$Y$8,C7)

Works perfect! Great thanks Ace

Big help as always, Appreciate pal

Originally Posted by Ace_XL

How about..
=IF(OR(C7=1,C7=2),H16,D16)*INDEX($Y$2:$Y$8,C7)

Hi, I have a drop down list in Cell R13 with multiple values to choose from - I would like to multiply the value I choose from that drop down list by the value in colum H13

I can't seem to attach the sheet, but essentially I in Cell R13 the drop list contains 5 values to choose the rate for a venue - I want to multiply that rate per week that the client books in cell H13 for example 2 week

How do I do this.

Thanks for your help