Solved Excel Drop Down impact next cell

October 29, 2017 at 18:56:37
Specs: Macintosh
Hi. I'm trying to set up a spreadsheet that contains a yes/no dropdown section. I figured out how to implement this. Now I want that the next column is impacted by the yes/no selection.

To be specific: I want that if "no" is selected, one formula is used for the column next to the dropdown menu. If "yes" is selected, another one is used.

How can I link those together?

Thank you in advance!

See More: Excel Drop Down impact next cell

Report •

October 29, 2017 at 21:54:25
✔ Best Answer
With your Drop Down list in cell A1, something like:


See how that works for you.


Report •
Related Solutions

Ask Question