Salesforce Developer Community

I have a 2 dropdowns. Depending on what is chosen in these 2 dropdowns determines what value will display in a 3rd dropdown.

How do I accomplish this in the fields area?

I also need to be able to override the formula manually on a limited basis.

Thanks in advance!