Is it possible to have 5 logics tested in an excel formula? Let's say I'm working with percentages and ranking each percentage 1 to 5. How would I write, for example with a value in B2, If B2 is < 1% it returns a value of 1, B2 between 1%-2% returnes a value of 2, 2%-3% returns 3, 3-4% returns a 4, and anything higher than 4% returns a value of 5. Any help would be appreciated.