Page 51 - KEC Khaitan C6 Flipbook
P. 51
2 Click on the Formulas tab.
3 Click on the
Insert Function
command.
1 Select the
cell where you
want the result
to be displayed.
4 Select the Logical option from the
Or select a category drop-down list.
7 Fill the required details. Now you will notice
that the condition is evaluated to be true and
the result is displayed below the IF frame.
5 Select the
IF function.
6 Click on the OK button. 8 Click on the OK button.
In the Logical test box, provide a condition that evaluates to be true or false. In the Value_if_true
box, provide a value that you want to display in the active cell if the condition evaluates to be true.
Similarly, in the Value_if_false box, provide a value that you want to display in the active cell if
the condition evaluates to be false.
Tick ( ) if you know this.
▶ The IF function allows us to check a condition and take action based on the results.
▶ The SUM function calculates the total of a given set of values.
Advanced Features of Excel 49

