I'm trying to convert a large dataset with numbers from 0-99 into classes. I.e. 1-5=1, 6-25=2, 26-50=3...etc... I cannot get an if/then statement to work...
what is wrong with this? =IF(G2<1, G2, IF(G2<=5, 1, IF(G2<=25, 2, IF(G2<=50,3, IF(G2<=75, 4, IF(G2<=95, 5, IF(G2<=100, 6, G2)))))))
all cells are returning zero... Checked to make sure data is entered as numbers, it is. Any tips?
what is wrong with this? =IF(G2<1, G2, IF(G2<=5, 1, IF(G2<=25, 2, IF(G2<=50,3, IF(G2<=75, 4, IF(G2<=95, 5, IF(G2<=100, 6, G2)))))))
all cells are returning zero... Checked to make sure data is entered as numbers, it is. Any tips?