FUNCTIONS USEING TEXT

[CHAMLIN]

HOW DO I USE A TEXT IN ONE CELL TO REPRESENT A NUMBER IN ANOTHER CELL

 

[Mark W.]

Care to elaborate with an example?

 

[CHAMLIN]

LIKE IF A3 HAS THE TEXT "D" THAN C3 WILL BE 7.5

 

[phantom1975]

WELCOME TO THE BOARD!

LIKE IF A3 HAS THE TEXT "D" THAN C3 WILL BE 7.5

In cell C3 you would put:

=if(A3="d",7.5,"")

This means that if A3 has D in it, then the cell will have 7.5. Otherwise, it will be blank ("").

 

[Mark W.]

On 2002-10-14 15:56, CHAMLIN wrote:
LIKE IF A3 HAS THE TEXT "D" THAN C3 WILL BE 7.5

What's the relationship between "D" and 7.5?

 

[CHAMLIN]

THANK YOU
WHAT IF IT HAS MULTIPLE FUNCTIONS
LI IF A3=D C3=7.5 AND IF A3=T C3=9.5

 

[Mark W.]

On 2002-10-14 16:18, CHAMLIN wrote:
THANK YOU
WHAT IF IT HAS MULTIPLE FUNCTIONS
LI IF A3=D C3=7.5 AND IF A3=T C3=9.5

=VLOOKUP(A3,{"D",7.5;"T",9.5},2,0)

 

[PaddyD]

a) stop shouting (i.e. take of the caps lock!)

b) use a lookup table that relates letters to values & a lookup formula to return the correct values...check the help files on vlookup(), search this board for examples...

Paddy

 

[phantom1975]

On 2002-10-14 16:18, CHAMLIN wrote:
THANK YOU
WHAT IF IT HAS MULTIPLE FUNCTIONS
LI IF A3=D C3=7.5 AND IF A3=T C3=9.5

A Visual Basic Macro works best, but here is the formula:

=if(A3="D",7.5,if(A3="T",9.5,""))

You can "nest" 7 "if" statements in one formula.

 

[Mark W.]

On 2002-10-14 16:22, phantom1975 wrote:

On 2002-10-14 16:18, CHAMLIN wrote:
THANK YOU
WHAT IF IT HAS MULTIPLE FUNCTIONS
LI IF A3=D C3=7.5 AND IF A3=T C3=9.5

A Visual Basic Macro works best, but here is the formula:

=if(A3="D",7.5,if(A3="T",9.5,""))

You can "nest" 7 "if" statements in one formula.

I believe a VLOOKUP function works best here.