Normally, when a formula is copied to other cells, theВ relative cell references in the formula change to reflect the formula's new location. In this example, when the data in cell D7 is less than $30,000,В Excel multiplies the employee's annual salary in cell D7 by the deduction rate of 6 percent located in cell D3. The Value_if_true argument can be a formula, a block of text, a value, a cell reference, or the cell can be left blank. The Value_if_true argument tells the IF function what to do when the Logical_test is true. The completed logical test displays as D7Press the less-than key ( Select cell D7 to add this cell reference to the Logical_test line.Select the Logical_test line in the dialog box.Since the goal is to determine if D7 is less than $30,000, the Less Than operator ( < ) is used between the values. The first comparison is between the employee's annual salary, located in cell D, with the threshold salary of $30,000. In this example, there are three salary levels that determine an employee's annual deduction:ДЄ single IF function can compare two levels, but the third salary level requires the use of the second nested IF function. To compare two values, the Logical_test uses a comparison operatorВ between the values.

This data can be numbers, cell references, the results of formulas, or even text data. The Logical_test argument compares two items of data. Or, follow through the next steps that offer detailed instructions and explanations for entering the three arguments.

Enter the arguments into the dialog box as shown in the image above and then jump to the final step that covers copying the formula to rows 7 through 10.These arguments tell the function the condition being tested and what actions to take if the condition is true or false.

The data entered into the blank lines in the dialog box form the arguments of the IF function.

Select IF in the list to bring up the function's dialog box.

Select Logical to open the function drop-down list.

This is where the nested IF formula will be located.

Select cell E7 to make it the active cell.

Since the worksheet calculates the annual deduction for several employees, the formula is first entered into cell E7 using absolute cell references for the deduction rates and then copied to cells E8:E11. In this example, the nested IF function is entered into the third line of the dialog box as the Value_if_false argument. A second dialog box cannot be opened to enter the second set of arguments. Using the dialog box is a bit trickier when entering nested functions because the nested function must be typed in. However, if you are using a desktop version of Excel, it is often easier to use the function's dialog box to enter the necessary arguments. In Excel Online, this is the method you must use. Into cell E7 of the worksheet and have it work. It is possible to just enter the complete formula The only data not entered at this point is the IF function itself located in cell E7.

If вЂ‹the salary is less than $50,000 but greater than $30,000,В $D$4*D7В multiplies the salary by the deduction rate of 8%.Д®nter the dataВ into cellsВ C1 to E6 of an Excel worksheetВ as seen in the image.

If the salary is equal to or greater than $50,000,В $D$5*D7В multiplies the salary by the deduction rate of 10%.

D7>=50000В checks to see if an employee's salary is greater than or equal to $50,000.

The different parts of the formula are separated by commas and carry out the following tasks: TheВ nestedВ IF function acts as the value_if_false argumentВ for the first IF function. The formula used in the example is shown below. As shown in the image, this tutorial uses two IF functions to create a formulaВ that calculates an annual deduction amount for employees based on their yearly salary.

Excel for mac 2011 nested if