=IF(AND($H$4>=0,$H$4<=299),"1",IF(AND($H$4>=300,$H$4<=899),"2",IF(AND($H$4>=900,$H$4<=2699),"3",IF(AND($H$4>=2700,$H$4<=6499),"4",IF(AND($H$4>=6500,$H$4<=13999),"5",IF(AND($H$4>=14000,$H$4<=22999),"6",IF(AND($H$4>=23000,$H$4<=33999),"7",IF(AND($H$4>=34000,$H$4<=47999),"8",IF(AND($H$4>=48000,$H$4<=63999),"9",IF(AND($H$4>=64000,$H$4<=84999),"10",IF(AND($H$4>=85000,$H$4<=99999),"11",IF(AND($H$4>=100000,$H$4<=119999),"12",IF(AND($H$4>=120000,$H$4<=139999),"13",IF(AND($H$4>=140000,$H$4<=164999),"14",IF(AND($H$4>=165000,$H$4<=194999),"15",IF(AND($H$4>=195000,$H$4<=224999),"16",IF(AND($H$4>=225000,$H$4<=264999),"17",IF(AND($H$4>=265000,$H$4<=304999),"18",IF(AND($H$4>=305000,$H$4<=354999),"19",IF(AND($H$4>=355000),"20"))))))))))))))))))))
This is my K4 cell..... I may have to try changing it in the morning.
Bookmarks