what function to use to calculate a value based on drop down list

hi all,

I am seeking for help what function shall I use to be able to calculate total value based on selected drop down list e.g.

Cell A4 has drop down list Hrs/MD
Cell B2 has value on Hrs =$22
Cell C2 has value on MD = $176
Cell D4 has value in units = e.g 10
cell E4 = total value base on selected drop down list

E.g. I select Hrs in A4, D4 has 10 Units, E4 = $220
E.g. I select MD in A4, D4 has 10 units, E4 = $1760

thanks for the help
H.

Try

=IF($A4="Hrs",$D4*$B$2,$D4*$C$2))

Try this:

=IF(A4="Hrs",B2,C2)*D4

You may need to change commas to semi-colons for your locale.

????

Is this it??

Is what it???

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.