Difference between revisions of "Manuals/calci/ADD"
Jump to navigation
Jump to search
(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...") |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''SUM( | + | <div style="font-size:30px">'''SUM()'''</div><br/> |
| − | <div style="font-size:30px">'''ADD( | + | <div style="font-size:30px">'''ADD()'''</div><br/> |
| − | + | *Parameters are any set of arguments for which to find the total. | |
| − | * | + | **ADD() adds its arguments. |
==Description== | ==Description== | ||
| Line 13: | Line 13: | ||
*The arguments can be <math>+ve</math> or <math>-ve</math>. | *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 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 | + | *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. | *The arguments can be up to any number. | ||
*If the arguments is an array or reference, only the constants are considered. | *If the arguments is an array or reference, only the constants are considered. | ||
| Line 26: | Line 26: | ||
#ADD((-20)..0) = -210 | #ADD((-20)..0) = -210 | ||
#ADD(2.25..34.50..3) = 189.75 | #ADD(2.25..34.50..3) = 189.75 | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=PfVSX7CNLKg|280|center|Sum}} | ||
==See Also== | ==See Also== | ||
Latest revision as of 15:00, 6 December 2018
SUM()
ADD()
- Parameters are any set of arguments for which to find the total.
- ADD() adds its arguments.
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
- 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 or .
- 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
or 
.- 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
Related Videos
See Also
References