Enter a formula in cell B10 to return a value of 35000 if the Net Profit After Tax (cell B9) is greater than or equal to 470000 or 100 if it is not.
Question
Enter a formula in cell B10 to return a value of 35000 if the Net Profit After Tax (cell B9) is greater than or equal to 470000 or 100 if it is not.
Solution
- Click on cell B10 to make it active for editing.
- Type the following formula:
=IF(B9>=470000, 35000, 100) - Press Enter.
This formula uses the IF function to check if the value in cell B9 is greater than or equal to 470000. If the condition is true, it returns 35000. If the condition is false, it returns 100.
Similar Questions
If you have net operating profit after tax of $100,000, capital employed of $500,000 and WACC of 10%, your economic value added is _______________560004500010000050000
A firm earned a profit of 40000 on the capital of 300,000. Normal rate of return is 10%.Calculate the value of good”wo points Income and Expenditure A/c with Profit and Loss A/c.(2)will at three years purchase of Super Profit
Enter a formula in the selected cell to calculate the profit projection for 2022: total sales (cell F4) minus the cost of goods sold (cell F5).
Use Goal Seek to find the value for cell C2 that will result in a value of $550,000 for cell B15. Accept the solution.
Question 3You are working on the sales data for office desks and want to calculate the total profits for the year 2020. What function would you use to calculate the total profits, which are located in the cell range B2 to B220?1 point= TOTAL (B2 : B220)= B2 + B220= B2 : B220= SUM ( B2 : B220)
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.