I have this formula that works perfectly, but it exceeds the argument requirements. Can someone pleas help me out condensing this so I can use it
IF(B7=1,"bucket 1",IF(B7>1+AND(B7<=90),"bucket 2"),IF(B7>90+AND(B7<=180),"bucket 3"),IF(B7>180+AND(B7<=360),"bucket 4"),IF(B7>360+AND(B7<=1800),"bucket 5","bucket 6"))
Bookmarks