How do I create "IF" function with a drop down list?
I have a worksheet with an option for a user to choose "0" to "3" in a cell
with a drop down list. Where "0" = N/A, "1" = NI (needs improvement), "2" =
No, and "3" = Yes. This option is located in cell "E16". What I want to do
is create an option for a new drop down list in adjacent cell "G16" which is
based upon the choice made in "E16". A user could choose from several
different appropriate answers for either "3", "2", "1", or "0".
|