Multiply Value from the drop down to a specific cell

[gmoolman]

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

[PFDave]

where do you want the result to be placed?

A simple sum can achieve what you're asking =SUM(R13*H13)

I suspect there is more to this than appears however so you will need to go advance, manage attachments, browse the sample file then upload for a better response.