Question

Write the steps to create ‘If’ function using formula tab and dialogue box on a given spreadsheet where the total income less expenses if greater than ₹ 10,000 then 10% savings and if income is less than ₹ 10,000 then 5% savings. Also write the syntax of the result.

Hint:

The 'If' function is a powerful tool in spreadsheets to make decisions based on specific conditions.

Answer 1

To create the IF function in a spreadsheet:

1. Click on the cell where the result is to be displayed.
2. Go to the formula tab and click on the “Insert Function” option.
3. In the dialogue box, select IF from the function list.
4. In the logical test field, enter the condition: =(income - expenses) < 10000.
5. In the value if true field, enter: =(income - expenses) * 10%.
6. In the value if false field, enter: =(income - expenses) * 5%.
7. Press “OK” to apply the formula

The syntax of the function is:

\[ \text{=IF((income - expenses) < 10000, (income - expenses) * 10\%, (income - expenses) * 5\%)} \]