How do I?
 

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

How do I?
 

Try:

=CHAR(B1-1000+64)

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"bondo" wrote in message
...
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

How do I?
 

Or of course just:

=CHAR(B1-936)

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"Sandy Mann" wrote in message
...
Try:

=CHAR(B1-1000+64)

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk


"bondo" wrote in message
...
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