Manuals/calci/ADD - Revision history

Devika: /* See Also */

2018-12-06T21:00:31Z

Devika at 22:04, 18 June 2018

2018-06-18T22:04:55Z

Devika at 22:03, 18 June 2018

2018-06-18T22:03:11Z

Devika: Created page with "
'''SUM(n1,n2,n3...)'''

'''ADD(n1,n2,n3...)'''

*where $n_1,n_2,n_3...$ are the argume..."

2017-05-30T19:42:44Z

Created page with "<div style="font-size:30px">'''SUM(n1,n2,n3...)'''</div><br/> <div style="font-size:30px">'''ADD(n1,n2,n3...)'''</div><br/> *where <math>n_1,n_2,n_3...</math> are the argume..."

New page

<div style="font-size:30px">'''SUM(n1,n2,n3...)'''</div><br/>
<div style="font-size:30px">'''ADD(n1,n2,n3...)'''</div><br/>

*where <math>n_1,n_2,n_3...</math> are the arguments for which to find the total.

==Description==

*This function gives the total sum value of given arguments.
*Sum is the operation of adding the sequence of numbers.
*The mathematical symbol for summation is <math>\sum </math>
*The numbers are adding together is called addends or summands.
*The summation of infinite sequence of values is called a series.
*The arguments can be <math>+ve</math> or <math>-ve</math>.
*We can give any cell references like column or row number, logical values like true or false, an array, or a result from any other functions in Arguments.
*We must give atleast one argument. i.e <math>n1</math> is required, and from <math>n2,n3...</math>it is optional.
*The arguments can be up to any number.
*If the arguments is an array or reference, only the constants are considered.
*The arguments are ignored, if
# It is empty cells
# It is logical values
# It is text.
*This function shows error value when the arguments cannot be changed to numbers.

==Examples==
#ADD(1,2,3,4,5,6,7) = 28
#ADD((-20)..0) = -210
#ADD(2.25..34.50..3) = 189.75

==See Also==
*[[Manuals/calci/SUM| SUM]]
*[[Manuals/calci/ADDBY| ADDBY]]
*[[Manuals/calci/AVERAGE| AVERAGE]]

==References==
*[http://en.wikipedia.org/wiki/Summation SUM]

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

@@ Line 1: / Line 1: @@
 <div style="font-size:30px">'''SUM()'''</div><br/>
 <div style="font-size:30px">'''ADD()'''</div><br/>
 *Parameters are any set of  arguments for which to find the total.
 ==Description==

@@ Line 26: / Line 26: @@
 #ADD((-20)..0) = -210
 #ADD(2.25..34.50..3) = 189.75
 ==See Also==

@@ Line 1: / Line 1: @@
-<div style="font-size:30px">'''SUM(n1,n2,n3...)'''</div><br/>
+<div style="font-size:30px">'''SUM()'''</div><br/>
-<div style="font-size:30px">'''ADD(n1,n2,n3...)'''</div><br/>
+<div style="font-size:30px">'''ADD()'''</div><br/>
-*where <math>n_1,n_2,n_3...</math> are  the arguments for which to find the total.
+*Parameters are any set of  arguments for which to find the total.
 ==Description==
@@ Line 13: / Line 13: @@
 *The arguments can be <math>+ve</math> or <math>-ve</math>.
 *We can give any cell references like column or row number, logical values like true or false, an array, or a result from any other functions in Arguments.
-*We must give atleast one argument. i.e <math>n1</math> is required, and from <math>n2,n3...</math>it is optional.
+*We must give at least one argument. i.e First parameter is required, and from second parameter are optional.
 *The arguments can be up to any number.
 *If the  arguments is an array or reference, only the constants are considered.

Manuals/calci/ADD - Revision history

Devika: /* See Also */

Devika at 22:04, 18 June 2018

Devika at 22:03, 18 June 2018

Devika: Created page with "'''SUM(n1,n2,n3...)''' '''ADD(n1,n2,n3...)''' *where n_1,n_2,n_3... are the argume..."

Devika: Created page with "
'''SUM(n1,n2,n3...)'''

'''ADD(n1,n2,n3...)'''

*where $n_1,n_2,n_3...$ are the argume..."