Formula Help update do not answer 1st post

B

B.B

Forget 1st post
Is there a formula so Cell A2 will enter in the following
A if cell A1 = 1
B if A1 = 2
C if A1 =3
D if A1 = 4
Thanks in Advance
 
S

ScottO

You may need to add some error-trapping to this via an IF function,
but you could try =CHAR(64+A1).
Rgds,
ScottO

| Forget 1st post
| Is there a formula so Cell A2 will enter in the following
| A if cell A1 = 1
| B if A1 = 2
| C if A1 =3
| D if A1 = 4
| Thanks in Advance
|
|
 
S

ScottO

Or =CHOOSE(A1,"A","B","C","D")
S
| =LOOKUP(A1,{1,2,3,4;"A","B","C","D"})
| Courtesy Ken Puls. :)
| ************
| Hope it helps!
| Anne Troy
| www.OfficeArticles.com
|
| > Forget 1st post
| > Is there a formula so Cell A2 will enter in the following
| > A if cell A1 = 1
| > B if A1 = 2
| > C if A1 =3
| > D if A1 = 4
| > Thanks in Advance
| >
| >
|
|
 
Top