Try this
=IF(AND(A1>=5,A1<7),"700",IF(AND(A1>=7,A1<10),"900",IF(AND(A1>=10,A1<15),"1000",IF(AND(A1>=15,A1<20),"1100",IF(A1>=20,"1200","")))))
Try this
=IF(AND(A1>=5,A1<7),"700",IF(AND(A1>=7,A1<10),"900",IF(AND(A1>=10,A1<15),"1000",IF(AND(A1>=15,A1<20),"1100",IF(A1>=20,"1200","")))))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks