26-05-2002
| #1 |
| CD Freaks Rookie Join Date: Jun 2000
Posts: 31
| 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 Thank You |
|  |
Today | |
| Register to remove me Join Date: Today Location: Myce HQ
Posts: Zillions
| |
|
26-05-2002
| #2 |
| CD Freaks Rookie Join Date: Jun 2000
Posts: 31
| I'm all set now, thanks for looking. |
|
| |
 |
| Thread Tools | |
| |
Similar Threads | ||||
| 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 |
