Formulas and Functions

Chapter 9 Reference Functions 209
AREAS
The AREAS function returns the number of ranges the function references.
AREAS(areas)
 areas: The areas the function should count. areas is a list value. It is either a single
range or more than one range separated by commas and enclosed in an additional
set of parentheses; for example, AREAS((B1:B5, C10:C12)).
Examples
=AREAS(A1:F8) returns 1.
=AREAS(C2:C8 B6:E6) returns 1.
=AREAS((A1:F8, A10:F18)) returns 2.
=AREAS((A1:C1, A3:C3, A5:C5)) returns 3.
Related Topics
For related functions and additional information, see:
“Listing of Reference Functions” on page 206
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
CHOOSE
The CHOOSE function returns a value from a collection of values based on a specied
index value.
CHOOSE(index, value, value…)
 index: The index of the value to be returned. index is a number value and must be
greater than 0.
 value: A value. value can contain any value type.
 value…:Optionally include one or more additional values.
Examples
=CHOOSE(4, “Monday”, “Tuesday”, “Wednesday”, “Thursday”, “Friday”, “Saturday”, “Sunday”) returns
Thursday, the fourth value in the list.
=CHOOSE(3, “1st”, “second”, 7, “last”) returns 7, the third value in the list.