The goal here is to write a formula that outputs the car class by reading its acceleration. If not, then read our guide on IF statements and how to use them in Excel. A great thing about the IF function is that you can nest it inside itself, which gives you the ability to create multiple conditions for your formula.īefore we get down to nested IF statements, here's a simple one: If you're already familiar with the IF function, then proceed to the next section. If it doesn't, then the formula will return another output. If the value passes the logical test, the formula will return the first output. With the IF function, you can write a condition or a logical test in your formula. Curious how? Read on to find out!Īn IF statement or an IF function is one of those functions in Excel that has the potential to take your formula to the next level and make more sophisticated tasks possible. You can take your IF statements to the next level, by nesting them inside each other. IF statements in Excel let you set conditions for your formula and tell it what to output when the condition is met or when it's not.
