Question

In case the total cost of a machine less installation charges is greater than Rs 2,00,000, then 20% depreciation is charged, and if total cost of the machine is less than Rs 2,00,000 then 10% depreciation is charged.
Write the steps to create the 'IF' function using the Formula tab and dialogue box on a given spreadsheet. Also, write the syntax of the result.

Hint:

The \texttt{IF} function allows conditional calculations: \texttt{IF(condition, value\_if\_true, value\_if\_false)}.
\begin{itemize} \item Use \texttt{num\_digits $>$ 0}: Rounds right of decimal (decimal places). \item Use \texttt{num\_digits = 0}: Rounds to nearest whole number. \item Use \texttt{num\_digits $<$ 0}: Rounds left of decimal (nearest 10, 100, etc.). \end{itemize} Excel also has \texttt{ROUNDUP} (always rounds away from zero) and \texttt{ROUNDDOWN} (always rounds towards zero).

Answer 1

To solve the problem, we need to create an IF function using the Formula tab and the Insert Function dialog box in a spreadsheet (e.g., Microsoft Excel) to calculate depreciation based on the total cost of the machine excluding installation charges.

1. Understanding the Condition:
We are told:

• If the total cost (excluding installation charges) is greater than Rs 2,00,000, then depreciation is 20%.
• If it is less than or equal to Rs 2,00,000, then depreciation is 10%.

2. Steps to Use the IF Function via the Formula Tab:

1. Click on the cell where you want the depreciation value to appear.
2. Go to the Formula tab on the Ribbon.
3. Click on Insert Function (fx) on the left.
4. In the Insert Function dialog box, search for "IF" and select it.
5. Click OK.
6. In the function arguments window:
   • Logical_test: Enter the condition (e.g., A2 > 200000).
   • Value_if_true: Enter the formula for 20% depreciation (e.g., A2*20%).
   • Value_if_false: Enter the formula for 10% depreciation (e.g., A2*10%).
7. Click OK to apply the function.

3. Syntax of the IF Function:
=IF(A2>200000, A2*20%, A2*10%)
Here, A2 represents the cell containing the total cost (excluding installation charges).

Final Answer:
The IF function is created using the Formula tab and dialog box, and the result is given by the syntax:
=IF(A2>200000, A2*20%, A2*10%)