If you find yourself with an IF statement that just seems to keep growing with no end in sight, it’s time to put down the mouse and rethink your strategy. Multiple IF statements can become incredibly difficult to maintain, especially when you come back some time later and try to figure out what you, or worse someone else, was trying to do. Unfortunately, the odds of you catching the 25% are slim. If you don’t nest your formula 100% accurately, then it might work 75% of the time, but return unexpected results 25% of the time. Multiple IF statements require a great deal of thought to build correctly and make sure that their logic can calculate correctly through each condition all the way to the end. While Excel will allow you to nest up to 64 different IF functions, it’s not at all advisable to do so. The value that you want returned if the result of logical_test is FALSE. The value that you want returned if the result of logical_test is TRUE. Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it's false.