Multiple if statement for between number ranges??

[ScuberSupreme]

I'm trying to figure out how to pull certain numbers for figures in between multiple ranges.

Below works but I was hoping to add to it so I could pull other figures for numbers between other ranges as well

=IF(AND(P6>4.9,P6<5.15),5,"")

=IF(AND(P6>4.9,P6<5.15),5,""),if(and(P6>5.15,P6<5.51) ect??

Please help

Scuber

 

[JoeMo]

Maybe:

=IF(AND(P6>4.9,P6<5.15),5,if(and(P6>5.15,P6<5.51),value if true,""))

 

[ScuberSupreme]

Legend!

Thankyou!