Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Think I have a good one here

Status
Not open for further replies.

KN3M3SIS

Programmer
Jun 2, 2003
18
US
So I have a column with number that range from 0 - 2,
then I have another that has some letters in it.

I want to be able to do something like.

If N# > 1 add the letter "A" to the string in B#
Else add the letter "B"

Example

N B RESULT
1.4 VE AVE
.9 E BE
.45 O BO
1.9 OS AOS

Thanks in advance!!!
 
Assuming that table starts in A1, formula in C2:
=IF(A2>1,"A","B")&B2

combo
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top