Check out our Excel Resources. Re: Combining IF and AND functions. You can only nest seven levels of IF statments, but you can reference a cell that includes additional IF statments to extend this limit. So, with this in mind you can replace the Else part with a new IF up to seven times. Note: AND(I5>0,I5<5) is: test1. ,1, is: Then 1. IF(And(I5>4,I5<9) is: test2.