An alternative is to calculate it in D1:

=CHAR(65+INT(C1/2))

assuming your numbers are in column C - copy down to cover your 400
numbers.

Hope ths helps.

Pete

On Mar 28, 4:13*pm, Dave P wrote:
I can't use VLOOKUP because the 400 or so values that I have do not match the
values in my column A, they are for example 1.3, 5.6 or 27.1



"Ron Rosenfeld" wrote:
On Fri, 28 Mar 2008 08:40:03 -0700, Dave P <Dave
wrote:

is there an alternative to using IF, as I believe one is limited to 7 IF
statements in a formulae.

My scenario is;

Column A contains 15 different values, let's say
1,3,5,7,9,11,13,15,17,19,21,23,25,27,29
Column B has corresponding Letters A,B,C,D,E,F,G,H,I,J,K,L,M,N,O

I would like to run a formula against approx 400 numbers, (most between 0 &
29) and return the corresponding letter

ie
IF A1 <=1,A,IF A1 <=3,B etc etc - obviously I can't use IF because I am
limited to 7 IFs.

Any suggestions greatly appreciated !!

Use VLOOKUP

--ron- Hide quoted text -

- Show quoted text -