If Statements and Ranges - Help!

I would like to merge the following formula so that if a value is entered into a cell in the following cell a letter will be returned depending on the value that was entered In the first cell.

The ranges I’m looking to use which will drive the letter returned are:
0-3 = A
3-7 = B
7-10 = C
10 + = D

I have the below formula which is currently calculating this using 4 different formulas over 4 different cells;
IF(AND(A1>=1,A1<=3),"A",0)
IF(AND(A1>=4,A1<=6),"B",0)
IF(AND(A1>=7,A1<=9),"C",0)
IF(A1>=10,"D",0)

If the above formula can be merged if you can let me know how then that would be great. Alternately if you know another way of doing this that would also be great.

Thanks!

=if(a1<=3,"a", if(a1<=6,"b", if(a1<=9,"c","d")))

Hi abbiegards92

Another option could be:
=LOOKUP(A1,{0,3,6,10},{"a","b","c","d"})

Blessing

Originally Posted by shukla.ankur281190

Hi Khalid It should be as below perhaps

=LOOKUP(A1,{1,4,7,10},{"a","b","c","d"})

Hi Ankur, Oops I overlooked in hurry, yes you are right.

criteria:
0-3 = A
3-7 = B
7-10 = C

but it should be something like:
0-3 = A
4-7 = B
8-10 = C

since we have to include 0-3 for "A"
=LOOKUP(A1,{0,4,7,10},{"a","b","c","d"})

Regards,

Originally Posted by TMS

I like the LOOKUP options but, just for fun:

Formula:

Please Login or Register  to view this content.

but this only works if the break points are multiples of three (3).

Regards, TMS

Hi TMS,
Nice way of CHOOSE...

Here is one more (no restriction) :
=CHOOSE(MATCH(A1,{0,4,7,10},1),"a","b","c","d")

Blessing