# FUNCTIONS USEING TEXT

#### CHAMLIN

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

### Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

#### Mark W.

##### MrExcel MVP
Care to elaborate with an example?

#### CHAMLIN

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

#### phantom1975

##### MrExcel MVP
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.

##### MrExcel MVP
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

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

#### Mark W.

##### MrExcel MVP
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)

##### MrExcel MVP
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...

#### phantom1975

##### MrExcel MVP
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.

##### MrExcel MVP
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.

Replies
2
Views
289
Replies
5
Views
522
Replies
0
Views
432
Replies
7
Views
377
Replies
1
Views
827

1,181,065
Messages
5,927,916
Members
436,576
Latest member
rovman1

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back