Difference between revisions of "Manuals/calci/CALCI SUM"
Jump to navigation
Jump to search
(Created page with "<div style="font-size:30px">'''CALCI_SUM(n1,n2,n3)'''</div><br/> where n1,n2,n3.. 'are the arguments for which to find the total. ==Description== *This function gives the t...") |
|||
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''CALCI_SUM(n1,n2,n3)'''</div><br/> | <div style="font-size:30px">'''CALCI_SUM(n1,n2,n3)'''</div><br/> | ||
| − | where n1,n2,n3.. 'are the arguments for which to find the total. | + | *where n1,n2,n3.. 'are the arguments for which to find the total. |
==Description== | ==Description== | ||
Revision as of 00:34, 11 November 2013
CALCI_SUM(n1,n2,n3)
- where n1,n2,n3.. 'are the arguments for which to find the total.
Description
- This function gives the total sum value of given arguments.
- The argument may be any type of numbers like '+' or '-'.
- Also 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.
- Here we must give more than one argument. i.e n1 is required, and from n2 ,n3....
- it is optional up to any number of arguments we can give.
- while giving the arguments is an array or reference only the constants are considered.
- The arguments are ignored if it is are empty cells,logical values or text.
- This function shows error value when the arguments cannot change in to numbers.
- COMPLEX(RN,IN,S)
- =COMPLEX(5,2) is 5+2i
- =COMPLEX(5,2,"j") is 5+2j
Examples
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 5 | 2 | 5+2i | 5+2j |
| Row2 | ||||
| Row3 | ||||
| Row4 | ||||
| Row5 | ||||
| Row6 |
