.

AREAS EXCEL FORMULA

EXCEL FORMULA
Function Dictionary Function Examples Function Categories

AREAS

         
 
Pink Name Age 2  =AREAS(PeopleLists)
Alan 18
Bob 17
Carol 20
Green Name Age
David 20
Eric 16
Fred 19
What Does It Do?          
This function tests a range to determine whether it is a single block of data, or whether
it is a multiple selection.
If it is a single block the result will be 1.
If it is a multiple block the result will be the number of ranges selected.
The function is designed to be used in macros.
Syntax            
 =AREAS(RangeToTest)
Formatting          
The result will be shown as a number.
Example            
The example at the top of this page shows two ranges coloured pink and green.
These ranges have been given the name PeopleLists.
The =AREAS(PeopleLists) gives a result of 2 indicating that there are two separate
selections which form the PeopleLists range.
Note            
To name multiple ranges the CTRL key must be used.
In the above example the pink range was selected as normal, then the Ctrl key
was held down before selecting the green range.
When a Range Name is created it will consider both Pink and Green as being one range.

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download