CD Freaks Rookie
Join Date: Jun 2000
Excel (I need some help)
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
Register to remove me
Join Date: Today
Location: Myce HQ
|Thread||Thread Starter||Forum||Replies||Last Post|
|excel help mij||wortel||Dutch: De Woonkamer||2||28-10-2005 23:28|
|Need help with excel||newlearner||Newbie Forum||1||14-10-2005 13:26|
|Excel probleem||Namoh||Dutch: De Woonkamer||5||22-07-2005 13:47|
|Barlijst in Excel||Greyhound6410||Dutch: De Woonkamer||4||03-10-2004 11:51|
|excel||popov1917||Italian: Chat||3||09-04-2002 09:56|