PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

INTRODUCTION TO FORMULAS:REFERENCE OPERATORS

KINDLY GO THROUGH What Excel does? How to use formula in Excel?

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

AND LOGICAL OPERATORS IN POST INTRODUCTION TO EXCEL FORMULAS:LOGICAL OPERATORS.

IN ADDITION TO THESE OPERATORS WE HAVE GOT REFERENCE OPERATORS TOO, WHICH ARE GOING TO BE USED A LOT WHEN USING FORMULAS IN EXCEL.

 

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 IN EXCEL(,)

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 IN EXCEL(space)

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 example

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

ANIMATED EXAMPLE OF intersection OPERATOR IN EXCEL

gyankosh animated reference operators excel
EXAMPLE: REFERENCE OPERATORS

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

%d bloggers like this: