Page 417 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

TASK 5 : Finding out Average of Positive Numbers
In this worksheet, you see there are some numbers in Column B of the worksheet. Some numbers are positive,
and some numbers are negative. We are going to find out the average of the positive numbers in this range.

You can do it in two ways. The first way is: separate the positive numbers manually, create a new range, and at
the end use the AVERAGE function to find out the average of the positive numbers. Another way is: we can use
an array formula. It will save us time and effort. So, without further delay, let’s see how we can do it.

Steps:
• Primarily, go to cell C5 and enter the following formula.
=AVERAGE(IF(B5:B14>0,B5:B14,FALSE))
Formula Breakdown
Observe closely the arguments of the IF function. You know how the IF function works. If the first argument of the
function is TRUE, then the second argument is returned by the IF function. If the first argument is FALSE, then
the third argument is returned by the IF function. Arguments are separated by commas.

In our case, the third argument is FALSE, so if the first argument is FALSE, then the IF function will return the
FALSE statement.

402
CITS : IT & ITES - Computer Software Application - Exercise 68