Simple question from a newbie

ckroon

Board Regular
Joined
Nov 9, 2005
Messages
60
Hey all... I am working on a spreadsheet where the number 5 needs to appear in cell C2, if there text is selected from a drop down list in cell b2.
I assume I will use the IF command, but after that I am lost.
Thanks!
 

rs2k

Well-known Member
Joined
Aug 15, 2004
Messages
1,413
You could use;

=IF(B2="FIVE",5," ")

change "FIVE" to your text.

But, would VLOOKUP not be better, if you had more choices/options?

Colin.
 

ckroon

Board Regular
Joined
Nov 9, 2005
Messages
60
also.....

What if I wanted a diffferent value to appear, other than a five if they selected a specif option form teh drop down menu?
Example: B6 list=Math, English,Other, blank
In C6 I have =IF(B2="","",5) which generates a 5 if the cell has something selected. How can I have it generate nothing if the selection is Other.
Is this possible?
 

rs2k

Well-known Member
Joined
Aug 15, 2004
Messages
1,413
How big is your list? and how is it set out?

Colin.
 

Forum statistics

Threads
1,078,070
Messages
5,338,035
Members
399,198
Latest member
PsycholoJackal

Some videos you may like

This Week's Hot Topics

Top