Ranges and IF's

[Pondcroft13]

Hi All,

I need a formula that lets me do the following:

I have a cell (A) that will have a number between 1 and 25. If the number is 1 or more but less than 9 then I want cell 'B' to =G(As in the letter not the column), if the cell is 9 or more but less than 20 I want cell 'B' to =A (As in the letter not the column), if the cell is 20 or more I want the cell to = R (As in the letter not the column).

Any ideas?

 

[Colin Legg]

Like this?

=IF(A1>=20,"R",IF(A1>=9,"A",IF(A1>=1,"G","")))

 

[Richard Schollar]

Hi

Try:

=LOOKUP(A1,{-9.9E+307,1,9,20,26},{"Out of bounds!","B","A","R","Out of bounds!"})

 

[Hooi]

Hi All,

I need a formula that lets me do the following:

I have a cell (A) that will have a number between 1 and 25. If the number is 1 or more but less than 9 then I want cell 'B' to =G(As in the letter not the column), if the cell is 9 or more but less than 20 I want cell 'B' to =A (As in the letter not the column), if the cell is 20 or more I want the cell to = R (As in the letter not the column).

Any ideas?

Try this

=IF(A1>0,IF(A1<9,"G",IF(A1<20,"A","R")))

Opps in the time i posting so much already replied..