Solved

Excel 97 - Make a drop down selection, and then calculate on it

Posted on 2001-07-27
3
177 Views
Last Modified: 2006-11-17
Howdy Experts -

I want to make a field in Excel where users can select text values from a drop down list, and then that value will be used in 'if' formulas elsewhere in the sheet.  Is this possible?

-Thorin
0
Comment
Question by:Thorin
  • 2
3 Comments
 
LVL 17

Accepted Solution

by:
calacuccia earned 100 total points
ID: 6328470
Hi Thorin,

You can do what you want by using the 'Data Validation' feature. Try this:

1/ Select cell to put drop-down in
2/ Go to Data/Validation
3/ On Tab 'Settings', set the drop-down 'Allow' to 'List'
4/ Make sure that 'In-Cell dropdown' is checked
5/ In the Text Box 'Source', type the different text entries, just separated by commas, like below

one,two,three,four

6/ Determine value selected by using the cell address of the data validation just created, for example:

=If(C5="one",1,If(C5="two",2,If(C5="three",3,If(C5="four",4,"N/A"))))

Good Luck
Calacuccia
0
 
LVL 2

Author Comment

by:Thorin
ID: 6334884
I wasn't going to give you the points because I was working in cell C8....but I figured you were close enough!  Just kidding...  :-)

Thanks very much that was exactly right, and you explained it very well.  Keep an eye out for more questions because I am sure this particular project I am working on will create more!

Thanks again...

-Thorin
0
 
LVL 17

Expert Comment

by:calacuccia
ID: 6334906
You're welcome, Thorin.

Keep 'em coming ;-)

calacuccia
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had the experience that you had to follow 10 steps over and over again every time when you need to nicely forward an important email to your manager? Fear no more! With the help of the Quick Steps feature in Outlook 2010, your old chor…
Introduction Perhaps more familiar to developers who primarily use VBScript than to developers who tend to work only with Microsoft Office and Visual Basic for Applications (VBA), the Dictionary is a powerful and versatile class, and is useful …
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question