Manuals/calci/AREAS - Revision history

Devika at 21:34, 6 August 2018

2018-08-06T21:34:02Z

2017-03-14T11:27:10Z

2015-05-26T18:28:42Z

2015-05-14T18:02:10Z

References

2013-11-22T11:15:21Z

2013-11-22T11:15:04Z

2013-11-22T11:11:07Z

References

2013-11-22T11:09:22Z

Examples

2013-11-22T10:54:15Z

2013-11-22T10:43:56Z

@@ 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.
 ==Description==

← Older revision		Revision as of 11:27, 14 March 2017
Line 30:		Line 30:
	==References==		==References==
	*[http://www.techonthenet.com/excel/formulas/areas.php Areas]		*[http://www.techonthenet.com/excel/formulas/areas.php Areas]
		+
		+
		+
		+	*[[Z_API_Functions \| List of Main Z Functions]]
		+
		+	*[[ Z3 \| Z3 home ]]

@@ Line 17: / Line 17: @@
   =AREAS(B2:G8:J5) is 1
   =AREAS(B2:D4:E5:F6:I9) is 1
 ==See Also==

← Older revision		Revision as of 18:02, 14 May 2015
Line 25:		Line 25:

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

@@ Line 21: / Line 21: @@
 *[[Manuals/calci/ADDRESS| ADDRESS]]
 *[[Manuals/calci/CELL| CELL]]
-**[[Manuals/calci/COLUMN| COLUMN]]
+*[[Manuals/calci/COLUMN| COLUMN]]
 *[[Manuals/calci/ROW| ROW]]
 ==References==

← Older revision		Revision as of 11:15, 22 November 2013
Line 19:		Line 19:

	==See Also==		==See Also==
		+	*[[Manuals/calci/ADDRESS\| ADDRESS]]
		+	*[[Manuals/calci/CELL\| CELL]]
		+	**[[Manuals/calci/COLUMN\| COLUMN]]
		+	*[[Manuals/calci/ROW\| ROW]]
		+
	==References==		==References==

← Older revision		Revision as of 11:11, 22 November 2013
Line 20:		Line 20:
	==See Also==		==See Also==
	==References==		==References==
−
−	~~{\| id="TABLE1" class="SpreadSheet blue"~~
−	~~\|- class="even"~~
−	~~\| class=" " \|~~
−	~~\| Column1~~
−	~~\| Column2~~
−	~~\| Column3~~
−	~~\| Column4~~
−	~~\|- class="odd"~~
−	~~\| class=" " \| Row1~~
−	~~\| class="sshl_f " \|~~
−	~~\| class=" " \|~~
−	~~\| class=" " \|~~
−	~~\| class=" sshl_f " \|~~
−	~~\|- class="even"~~
−	~~\| class=" " \| Row2~~
−	~~\| class=" " \| 7~~
−	~~\| class="sshl_f" \| 2~~
−	\|
−	\|
−	~~\|- class="odd"~~
−	~~\| Row3~~
−	~~\| class=" " \|~~
−	~~\| class=" " \|~~
−	\|
−	\|
−	~~\|- class="even"~~
−	~~\| Row4~~
−	\|
−	\|
−	~~\| class=" " \| 10000~~
−	\|
−	~~\|- class="odd"~~
−	~~\| class=" " \| Row5~~
−	\|
−	\|
−	~~\| class=" " \|~~
−	\|
−	~~\|- class="even"~~
−	~~\| Row6~~
−	\|
−	\|
−	\|
−	~~\| class=" SelectTD sshl_f sshl_t SelectTD" \|~~
−
−	\|}

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''AREAS(ref)'''</div><br/>
 <math>ref</math> is a reference to a cell or range of cells and can refer to multiple areas.
 ==Description==
-*It gives the number of areas in a reference. </font></font></font></div>
+*It gives the number of areas in a reference.
-  Let's see an example</font></font></font>
+*It should be surrounded with brackets, if there is more than one range.
+*The area can be single cell or many continuous cells
   =AREAS(B3:D5) is 2
 {| id="TABLE1" class="SpreadSheet blue"