Hi guys, I hope you can help me. I want to achieve something in Excel but I don't know if it's even possible.
I created a dropdownmenu and I want an if-function that checks if option 1 from the dropdownmenu is present and if it is, a number of cells in my table shall be set to 0 or multiplicated with 0. They should always become 0 when option 1 of the dropdownmenu is chosen.
The thing is, I can't (or at least I don't know how) write the formula in the before mentioned cells, cause these cells also are "input-cells". i.e. in case option 2 of the droptdown menu is chosen, specific values have to be put into these cells. In that case the formula should either do nothing or multiplicate those values with 1, as to not change them.
Since I'm not really proficient with formulas in Excel I created something like this, in a seperate cell outside of the dropdownmenu and outside the mentioned "input-cells":
cell containing formula: B1
=IF(A1="Basic";B10="(B10*0)";B10="(B10*1)") --> example for only one cell; usually I'd encase A and B in $'s
Ok this obviously doesn't work. I guess I need some kind of "if option 1 is true, do this at that location" like thing.
So is there a way to make that possible?
cheers
Bookmarks