| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating values based on selection from a drop-down list in Exc
I'm trying to get Excel to calculate different mathematical values based on
the user's selection from a drop-down list. The list contains various lengths of drywall sheets and I want the program to calculate the square footage of the sheets based on the one selected. Can't figure it out. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating values based on selection from a drop-down list in Exc
Since you mention length only I will assume width is a constant......4 maybe?
Select A1 and DataValidationList In the Source dialog enter 4,6,8,10,12,14,16 up to whatever. Note these are comma-delimited. In B1 enter =A1*4 Gord Dibben MS Excel MVP On Fri, 11 Jul 2008 16:52:09 -0700, Razzamatazz wrote: I'm trying to get Excel to calculate different mathematical values based on the user's selection from a drop-down list. The list contains various lengths of drywall sheets and I want the program to calculate the square footage of the sheets based on the one selected. Can't figure it out. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating values based on selection from a drop-down list in
Not exactly what I was looking for, but I got it figured out. Reading other
posts I discovered the &IF command and that did it. Thanks for looking though :) "Gord Dibben" wrote: Since you mention length only I will assume width is a constant......4 maybe? Select A1 and DataValidationList In the Source dialog enter 4,6,8,10,12,14,16 up to whatever. Note these are comma-delimited. In B1 enter =A1*4 Gord Dibben MS Excel MVP On Fri, 11 Jul 2008 16:52:09 -0700, Razzamatazz wrote: I'm trying to get Excel to calculate different mathematical values based on the user's selection from a drop-down list. The list contains various lengths of drywall sheets and I want the program to calculate the square footage of the sheets based on the one selected. Can't figure it out. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculating values based on selection from a drop-down list in
Could you please elaborate on this?
Post the formula. Gord On Fri, 11 Jul 2008 17:25:00 -0700, Razzamatazz wrote: Not exactly what I was looking for, but I got it figured out. Reading other posts I discovered the &IF command and that did it. Thanks for looking though :) "Gord Dibben" wrote: Since you mention length only I will assume width is a constant......4 maybe? Select A1 and DataValidationList In the Source dialog enter 4,6,8,10,12,14,16 up to whatever. Note these are comma-delimited. In B1 enter =A1*4 Gord Dibben MS Excel MVP On Fri, 11 Jul 2008 16:52:09 -0700, Razzamatazz wrote: I'm trying to get Excel to calculate different mathematical values based on the user's selection from a drop-down list. The list contains various lengths of drywall sheets and I want the program to calculate the square footage of the sheets based on the one selected. Can't figure it out. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying Drop down list items based on selection of another colu | Excel Discussion (Misc queries) | |||
| Formula to populate a drop down list based on the selection of ano | Excel Discussion (Misc queries) | |||
| count based on selection from drop down list | Excel Worksheet Functions | |||
| Move entire row to another worksheet based on drop list selection | Excel Worksheet Functions | |||
| How do I assign a set of values to a selection from a drop list? | New Users to Excel | |||
Hybrid Mode
