I'm trying to create a simple drop down menu with 2 choices.
Choice #1 text will produce a value of 22
Choice #2 text will produce a value of 24
The value will then be converted by another formula (below).
I'd like to use either a drop box, or some sort of check box. If a check box or option button is used, we could have it default to one value (22), then if the box is checked, change to the other.
the formula I am using in F12 which is the main one is =AVERAGE(F7:F8)21/(4(F10))+13.25
I'd like F10 to be selectable in some way. Currently a user has to enter a number manually, I'd like the drop box, or button to take care of that.
Is this possible?
Here is the file to look at CLICK HERE