Question

b. How to write the formula in Microsoft Excel - In cell C13, enter a formula using an IF function that tests whether cell C9 is greater than 230,000. If it is, multiply cell C9 by 0.20 to calculate the 20 percent eligible amount. If cell C9 is not greater than 230,000, multiply cell C9 by 0.15 to calculate the 15 percent eligible amount

Answer 1

The formula in Microsoft Excel, using the IF function with the specified conditions is =IF(C9>230000, C9*0.20, C9*0.15)

Step-by-step explanation:

The IF function is a premade function in Excel, which returns values based on a true or false condition.

The condition is referred to as logical_test , which can check things like: If a number is greater than another number > If a number is smaller than another number <.

To write the formula in Microsoft Excel, follow these steps:

• In cell C13, enter the formula with the IF function: =IF(C9>230000, C9*0.20, C9*0.15)
• This formula uses the IF function to test whether cell C9 is greater than 230,000.
• If it is, the formula multiplies cell C9 by 0.20 to calculate the 20 percent eligible amount. If cell C9 is not greater than 230,000, the formula multiplies cell C9 by 0.15 to calculate the 15 percent eligible amount.
• Press Enter to apply the formula and see the result.