Been trying to figure out how to do this for sometime, but no functions or formulas have worked.
I have a Selection box, I7, that is simply YES or NO. If the User chooses YES then I need a way to add 50 to another cell, I4, and if they select NO then no values are changed or added.
There are two ways I have thought about doing this. One is more straightforward by trying to set up I4 to add the 50 on top of it’s base value if I7 Equals “YES”. I haven’t been able to to get a Formula to work, Because I’m not sure how to set it up, usually getting Error 509-512 or it not recognizing the Value or Name.
The second idea was setting up a dummy cell to hold the value needing to be added to I4. So something along the lines of I7=“YES” then J7=“50”. Then I can just easily have I4+I7 and if I7=“NO” then no value will appear in J7 allowing I4 to just be the base value inputted. Problem again is I’m not sure how to set it up.
So anyone can help figure out one of these methods, or both, or another way to accomplish what I’m trying to do it would be much appreciated.