Oct 05 2020 04:20 AM
Hi,
I have a cell with a drop down menu and I need to get another cell to changed for the different items on the menu how can I do this (there is a different formula for each drop down item)
thank you
Oct 05 2020 04:45 AM
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
Oct 05 2020 05:29 AM - edited Oct 05 2020 05:31 AM
Switch?
https://support.microsoft.com/en-us/office/switch-function-47ab33c0-28ce-4530-8a45-d532ec4aa25e
If you have the drop-down in A1
You could have something like this in your “target” cell.
=SWITCH(A1,"x",”Formula1”,"y",”Formula2")
example
=SWITCH(A1,"x",E1+F1,"y",E1*F1)
The “target” will show the result of different formulas depending on what you chose in the dropdown (x or y)
Oct 05 2020 05:47 AM