Use a nested IF statement to convert numeric scores to letter grades. If your formula returns an error, count your parentheses. Note: Every open, left parenthesis in a formula must have a matching closed, right parenthesis. The student’s names are listed in column A numerical scores in Column B and the letter grades in column C, which are calculated by a nested IF statement.Ī. The syntax for a nested IF statement is this: IF data is true, then do this IF data is true, then do this IF data is true, then do this IF data is true, then do this else/otherwise do that. This example uses a “nested” IF statement to convert the numerical Math scores to letter grades. Convert scores to grades with nested IF statements Use an IF statement to calculate sales bonus commissions. This formula sums the total bonus dollars for the current month. Enter this formula in cell D15: =SUM(D4:D13). This formula copies the percentage from column C for sales greater than $10,000 or the words 'No Bonus' for sales less than $10,000 into column D.Ĭ. Enter this formula in cell C4: =IF(B410000, C4, “No bonus”), then copy from D4 to D5 through D13. Just change the names at the beginning of each quarter, enter the new grades at the end of each quarter, and Excel calculates the results.Ī. Once the formulas are entered, you can continue to reuse this spreadsheet forever. The information in column C is attained by using an IF statement. Column A lists the participants’ names column B shows their scores and column C displays whether they passed or failed the course. Scores of less than 70 percent fail, and those scores greater than that, pass. The Oregon Lifeguard Certification is a Pass/Fail test that requires participants to meet a minimum number of qualifications to pass. Use an IF statement to flag past-due accounts so you can send notices to those customers. In English, this formula means: If the date in cell A4 minus today’s date is greater than 30 days, then enter the words ‘Past Due’ in cell B4, else/otherwise enter the word ‘OK.’ Copy this formula from B4 to B5 through B13. Enter the formula: =IF(A4-TODAY()>30, “Past Due”, “OK”) in cell B4. Enter the formula: =TODAY() in cell A1, which displays as the current date.ī. The bookkeeper enters a formula in column B that calculates which customers are more than 30 days past due, then sends late notices accordingly.Ī. The company accountant enters the date that each payment arrives, which generates this Excel spreadsheet. In this spreadsheet, the customer’s payment due date is listed in column A, the payment status is shown in column B, and the customer’s company name is in column C. Here are five easy IF statements to get you started. Remember: Learning Excel functions/formulas and how they work are the first steps toward using Visual Basic, Microsoft’s event-driven programming language. IF statements are used in all programming languages and, although the syntax may vary slightly, the function provides the same results. The syntax (or sentence structure that is, the way the commands are organized in the formula) of an Excel IF statement is: =IF(logic_test, value_if true, value_if_false).
#HOW TO DO A IF THEN FORMULA IN EXCEL WINDOWS#
For example, if it’s raining, then close the windows, else/otherwise leave the windows open. If something is true, then do this, else/otherwise do that. The IF statement is also known as a logical formula: IF, then, else. Just like a yes-no question, if the specified condition is true, Excel returns one user-determined value and, if false, it returns another. Today we’ll tackle IF statements, a string of commands that determine whether a condition is met or not. Excel functions, or formulas, lie at the heart of the application’s deep well of capabilities.