Page 50 - KEC Khaitan C6 Flipbook
P. 50
4 Select the Math & Trig option from the
Or select a category drop-down list. 7 To calculate the sum of numbers
in cells C2 to H2, the range must be
specified as C2:H2 in the Number1 box.
5 Select the SUM function.
6 Click on the OK button. 8 Click on the OK button.
The sum is displayed
in the active cell.
Subject: How to calculate average
To calculate the average of given numbers in defined range of cells,
enter the formula =AVERAGE(number1, number2, number3, ...
number n). For example, =AVERAGE (4,5,6) will be 5.
IF()
The IF() function checks a condition to evaluate whether it as true or false and based on the
result, suitable actions are performed. This function takes three arguments into consideration:
the condition, the value to be displayed when the condition is true, and the value to be displayed
when the condition evaluates to be false.
48 Premium Edition-VI

