INTRODUCTION TO FORMULAS:REFERENCE OPERATORS

IF YOU HAVEN’T VISITED YET. ARITHMETIC OPERATORS WERE ALREADY DISCUSSED IN THE POST INTRODUCTION TO EXCEL FORMULAS:ARITHMETIC OPERATORS

RANGE OPERATOR IN EXCEL(:)

RANGE OPERATOR is used by the sign COLON “:”.

Range operator gives the reference to all the address which come between the two operators.

e.g. if we use as A1:A15

it takes all the cell between A1 and A15 including A1 AND A15.

e.g. If we want to sum up all the cells from A1 to A15 we’ll type this function.

=Sum(A1,A2….A15) OR with the help of Range operator we can write

=Sum(A1:15)

*The exact example shown at the end of article.

UNION OPERATOR is used by the sign COMMA “,”.

UNION OPERATOR combines the references of two ranges into one reference.

For example

Suppose there are two ranges A1:A5 and other range from B1:B5 and we want to sum up all the cells the formula will be like this one.

=SUM(A1:A5,B1:B5)

*SUM is a function meant for summing up the contents.

*The exact example shown at the end of article.

INTERSECTION OPERATOR is used by the sign SPACE ” “.

INTERSECTION OPERATOR (AS MEANT BY INTERSECTION IN THE SET THEORY) refers to the cells common in the two ranges.

For exampleSuppose there are two ranges A1:A5 and A3:A7it’ll be used as=SUM(A1:A5 A3:A7)*The exact example shown at the end of article.