Drop down list in A1 that changes numerical value in D1 depending on what was selected

Hello Excel Wizards!

I'd really like some help on this. Please see attached screenshot.

There are two enrollment types: Certified and Pre-certified. I know how to make a drop down list for these.

I want Certified to be assigned a value of $15 and Pre-certified to be assigned a value of $8. Whichever is selected, I'd like that value to be multiplied by the number of days in a different column, which spits out a total in another column.

I hope this makes sense! I thank you endlessly in advance for any help you can give.

JAMES.PNG

click on cell A1

select the data tab

select data validation

select data validation

select Allow then list

in source: Type Certified, Pre-Certified

click ok.


in cell d1.

Enter the formula:

=IF(A1 ="Certified", 15,8)

mehmetcik: Thank you

Now if I want to multiply the value 15 or 8 by the total number of days:

=IF (A1="Certified", 15,8) multiplied by # of day column = Total

Never mind, I figured it out exactly how I want it. Thank you!! SOLVED.