Step by step explanation:
Statement to be written in cell B10 :
IF ( B9 >= 350000 , 35000, 1000)
Formula:
IF ( logical_test , [value_if_true] , [value_if_false] )
logical_test = Net Profit After Tax (cell B9)
value_if_true = 35000
(if the Net Profit After Tax (cell B9) is greater than or equal to 350000)
value_if_false = 1000
(if the Net Profit After Tax (cell B9) is lesser than 350000)
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
brainly.com/question/2617534
2. Learn more about the income tax
brainly.com/question/2996312
3. Learn more about the excise tax
brainly.com/question/8827242
4. Learn more about the role of money
brainly.com/question/12984919
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
