How do I?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If cell B1 = 1001, I would like cell A1 to reflect "A".
If cell B2 = 1002, then cell A2 should be "B" and so on.
And if cell B1 = 1003, then cell A1 should be "C".
I need column A to read A,B or C based on column B being a value of 1001-1003.
Make sense?

TIA
Bill Bondo
 
Try:

=CHAR(B1-1000+64)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
Or of course just:

=CHAR(B1-936)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Standand Deviation as array 6
Find and return multiple values 2
Merge data from two separate tables 1
Vlookups (sum of) 7
Function IF and OR together 2
How to Match to table 1
Define Name - same name for multiple cells on multiple sheets 6
match?? 1

Back
Top