Imagine if you had to test for five conditions. This will provide the third argument and closing parentheses for the first IF statement. Gotcha: Don't forget to type the ,0) at the end of the formula. Using a second IF statement as the second argument.In this case, the second argument is another IF statement that checks to see if the GP% is over 50%. The second argument holds a formula to use when the logical test is true. This first checks if the revenue is over $20,000. The most common solution is nesting one IF statement inside of another. Strategy: There are three common solutions to this problem: nesting IF statements, using AND, using boolean formulas. The GP% must be 50% or higher in addition to the sale being over $20,000. Next, we extend the IF function to the relevant cell range within the ‘Status’ column, to see the result for each fruit:Īs a result we can see exactly which fruits we need to re-order.Problem: The CFO decided we should only pay the 2% bonus if a second condition is met. When we press enter, the function will publish the result for FALSE: No action, because the value in cell B2 isn’t less than 20. We call the function in the ‘status’ column: =IF(B2<20 ”Order” ”No action”): IF the amount is 20 or more (FALSE), we don’t have to take any action. IF the amount of a certain fruit is under 20 (TRUE), we need to place an order. The IF function can help us with this task. Whenever the amount in stock is less than 20, we need to place a new order with the wholesaler. We own a greengrocery and we have a list of fruits in stock. A value to return if the logical test results in FALSE.įormat: =IF(A1>B2 “TRUE” “FALSE”) Example.A value to return if the logical test results in TRUE.A logical test, using an operator sign for logical comparison.An IF function in Excel consists of 3 components:

How to do an if then formula in excel