Changes

187 bytes added , 21:34, 6 August 2018

no edit summary

Line 1: Line 1: −

<div style="font-size:30px">'''AREAS(~~ref~~)'''</div><br/>

+

<div style="font-size:30px">'''AREAS()'''</div><br/>

−

~~<math>ref</math>~~ is a reference to a cell or range of cells and can refer to multiple areas.

+

*Parameter is a reference to a cell or range of cells and can refer to multiple areas.

+

**AREAS(), returns the number of areas in a reference.

+

==Description==

Line 17: Line 19:

=AREAS(B2:G8:J5) is 1

=AREAS(B2:D4:E5:F6:I9) is 1

+

==Related Videos==

+

==See Also==

Line 26: Line 32:

==References==

*[http://www.techonthenet.com/excel/formulas/areas.php Areas]

+

*[[Z_API_Functions | List of Main Z Functions]]

+

*[[ Z3 | Z3 home ]]

writer

6,694

edits

Manuals/calci/AREAS (view source)