enter a formula in cell b10 to return a value of 35000 if the net profit after tax (cell B() is greater than or equal to 350000
or 1000 if it is not.
2 answers:
For the given problem, the solution is calculated below and also shown in Figure 1.
Further Explanation:
The statement that can be written in B10 cell is as below:
IF ( B9 >= 350000 , 35000, 1000) = IF (A>=B, yes, no)
The formula to calculate the net profit after tax is as below:
IF ( logical_test , [value_if_true] , [value_if_false] )
The logical test is calculated as below;
logical_test = Net Profit After Tax (cell B9)
If the Net Profit After Tax (cell B9) is greater than or equal to 350000
value_if_true = 35000
If the Net Profit After Tax (cell B9) is lesser than 350000
value_if_false = 1000
Therefore, it can be concluded that the value is true for 35000 and false for the value 1000.
Learn more:
1. Learn more about the tax on the sale of an asset
2. Learn more about the income tax
3. Learn more about the excise tax
4. Learn more about the role of money
Answer details:
Grade: Middle School
Subject: Business Studies
Chapter: Taxation
Keywords: Taxation, formula, cell. B10, B20, return, value, 350000, 1000, greater than, equal to, net profit, after tax, logical test, true, false, statement, condition
You might be interested in
The answer & explanation for this question is given in the attachment below.
