FUNCTIONS USEING TEXT

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

phantom1975

MrExcel MVP
Joined
Jun 3, 2002
Messages
3,962
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
Joined
Feb 10, 2002
Messages
11,654

ADVERTISEMENT

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
Joined
Oct 13, 2002
Messages
3
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
Joined
Feb 10, 2002
Messages
11,654

ADVERTISEMENT

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

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
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

MrExcel MVP
Joined
Jun 3, 2002
Messages
3,962
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
Joined
Feb 10, 2002
Messages
11,654
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.
 

Forum statistics

Threads
1,144,150
Messages
5,722,797
Members
422,459
Latest member
Chriselff

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top