Calculating values based on selection from a drop-down list in Exc

R

Razzamatazz

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.
 
G

Gord Dibben

Since you mention length only I will assume width is a constant......4 maybe?

Select A1 and Data>Validation>List

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
 
R

Razzamatazz

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
:)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using drop-down lists 4
Data Validation - Conditional List 3
Connecting drop down list selection to data 3
How do I change contents of a cell based on drop down list selecte 2
Excel Already selected values from DropDown list dynamically updating on multiple sheets 10
Form drop down list 3
validation drop down list question 1
Calculating the Sum of Drop-down list content control values (vs. display) 1

Top