How do I?

B

bondo

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
 
S

Sandy Mann

Try:

=CHAR(B1-1000+64)

--
HTH

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
S

Sandy Mann

Or of course just:

=CHAR(B1-936)

--
HTH

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top