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.
0 Comments
Leave a Reply. |