Manuals/calci/CALCI SUM

Revision as of 01:33, 11 November 2013 by Jayaram (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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