I'd like to make one formula to test for 7 different ranges of values in column A and assign a value of 1 - 7 in column B depending on the value in column A. For example if column A1 had a value of 235 B1 would get assigned a value of 4 because it is greater than 233 but less than or equal to 6,210.


HTML Code: