The formula for me was
E4 = (B4/C4)
G4 = IF(E4>=1.57 AND E4<=1.67, "5", IF(E4>=1.52 AND E4 <=1.77, "3", "1"))
Checks to see if you're in range 1 first, if you are, G4 is "5"
If not, checks if see if you're in range 2, if you are "3"
Else, you're outside of the range "1"