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.

Question

Let \(y=y(x)\) be the solution of the differential equation \[ x\frac{dy}{dx}=y-x^2\cot x,\quad x\in(0,\pi) \] If \(y\!\left(\frac{\pi}{2}\right)=\frac{\pi^2}{2}\), then \[ 6y\!\left(\frac{\pi}{6}\right)-8y\!\left(\frac{\pi}{4}\right) \] is equal to:

Answer 1

To implement the IF function in a spreadsheet:

Select the cell designated for the output.
Navigate to the formula tab and select "Insert Function".
Within the dialog box, choose IF from the available functions.
In the logical test field, input the following condition: =(income - expenses) < 10000.
For the value if true field, enter: =(income - expenses) * 10%.
For the value if false field, enter: =(income - expenses) * 5%.
Click "OK" to finalize the formula.

The function's syntax is:

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

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.

Show Hint

Solution and Explanation

Top Questions on Miscellaneous

Questions Asked in CBSE Class XII exam