Nested If and less than or equal to

[excelusername]

I am trying to put together a nested if statement that contains a number of less than or greater than calculations.

i.e if (A2 <60,A,(if A2>60<70,B,if(A2>70>80,C,if(A2>80,D))))

I can get a result if A2 is less than 60 or greater than 80 but the middle ones don't work. I have looked at adding AND in but can't get that to work either.
Any suggestions?

 

[Fluff]

Hi & welcome to MrExcel
how about
=IF(A2>80,"D",IF(A2>70,"C",IF(A2>60,"B","A")))

 

[excelusername]

Hi & welcome to MrExcel
how about
=IF(A2>80,"D",IF(A2>70,"C",IF(A2>60,"B","A")))

Oh yes, my brain just didn't think of it in that way. Great thank you.

 

[Fluff]

Glad to help & thanks for the feedback