Difference between revisions of "Manuals/calci/SUMBY"
Jump to navigation
Jump to search
(Created page with "SUMBY") |
|||
Line 1: | Line 1: | ||
− | SUMBY | + | <div style="font-size:30px">'''SUMBY(Number1,Number2) '''</div><br/> |
+ | *<math>Number1</math> and <math>Number2</math> are any real numbers. | ||
+ | |||
+ | ==Description== | ||
+ | *This function shows the sum of the first two numbers. | ||
+ | *In <math>SUMBY(Number1,Number2)</math>,<math>Number1</math> and <math>Number2</math> are any real numbers. | ||
+ | *The mathematical symbol for summation is <math>\sum </math>. | ||
+ | *The numbers are adding together is called addends or summands. | ||
+ | *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. | ||
+ | *In the arguments are first two numbers only considered. | ||
+ | |||
+ | ==Examples== | ||
+ | #SUMBY(90,34) = 124 | ||
+ | #SUMBY(120,-45) = 75 | ||
+ | #SUMBY(3/4,7/8) = 1.625 | ||
+ | |||
+ | ==See Also== | ||
+ | *[[Manuals/calci/SUM| SUM]] | ||
+ | *[[Manuals/calci/PRODUCT| PRODUCT]] | ||
+ | |||
+ | ==References== | ||
+ | *[http://en.wikipedia.org/wiki/Summation SUM] | ||
+ | |||
+ | |||
+ | |||
+ | *[[Z_API_Functions | List of Main Z Functions]] | ||
+ | *[[ Z3 | Z3 home ]] |
Revision as of 13:16, 10 May 2017
SUMBY(Number1,Number2)
- and are any real numbers.
Description
- This function shows the sum of the first two numbers.
- In , and are any real numbers.
- The mathematical symbol for summation is .
- The numbers are adding together is called addends or summands.
- 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 atleast one argument.
- In the arguments are first two numbers only considered.
Examples
- SUMBY(90,34) = 124
- SUMBY(120,-45) = 75
- SUMBY(3/4,7/8) = 1.625
See Also
References