To solve the problem, we need to write the steps to create an 'IF' function in Excel using the Formula tab and dialog box to apply depreciation rules based on the cost of the machine (excluding installation charges).
1. Understanding the Condition:
We are given:
2. Steps to Create an IF Function Using the Formula Tab and Dialog Box:
IF
in the search box and press Go.=A2>200000
(Assuming A2 contains the cost excluding installation)A2*20%
A2*10%
3. Syntax of the IF Function:=IF(A2>200000, A2*20%, A2*10%)
Here, A2 is assumed to be the cell containing the cost of the machine (excluding installation charges).
Final Answer:
The IF function is created using the Formula tab and dialog box, and the correct syntax is:=IF(A2>200000, A2*20%, A2*10%)
"___ how little changes in the environment can have big repercussions" Tishani Doshi in Journey to the End of the Earth gives an awakening call for man. Analyse the theme of the lesson in the light of the above statement.