GuidePedia

0
The INDIRECT function returns the reference specified by a text string.
1. For example, the INDIRECT function below reduces to =INDIRECT("C2"), =C2, 5
Cell
Do we really need the INDIRECT function for this? Yes. Below you can find the result without using the INDIRECT function.
Without Indirect Function
2. For example, the function below reduces to =SUM(INDIRECT("E3:E6")), =SUM(E3:E6), 27
Range
Note: the & operator is used to join strings. Border for illustration only.
3. For example, the function below reduces to =AVERAGE(Scores), 9
Name
Note: the named range Scores refers to the range C2:C4.
Did you find this information helpful? Show your appreciation.

Post a Comment

Blogger Tips and TricksLatest Tips And TricksBlogger Tricks

Visitors

Cloud Power For You

Website Hosting At Low Price

Contatc

Empire Views
 
Top