change a cell depending upon the content of another cell

Is it possible in excel to make a cell change depending upon what another cell says?

For example: One cell has a dropdown list with inputs "yes" and "no." Can you make another cell automatically change to something depending on which option is selected?

Any input would be greatly appreciated. Thanks.

Please revise your thread title to something more descriptive of the problem at hand.

Hi TNF,

You could probably use a conditional formula (IF) like so:

=IF(B2="yes",15,0)

Let's say you put that formula in C2. If the value in cell B2 is "yes", then C2 will show 15, otherwise it will show 0.

Another example:

=IF(B2="no","Needs Input","")

In this example, if B2 is "no", then the cell with this formula will show "Needs Input" (without the quotes). If B2 is something other than "no", then this cell will be blank ("").