Difference between revisions of "Manuals/calci/ADD"

Revision as of 16:03, 18 June 2018

SUM()

ADD()

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 $\sum$
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 $+ve$ or $-ve$ .
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 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.
The arguments are ignored, if

This function shows error value when the arguments cannot be changed to numbers.

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