writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 5:
Line 5: − + − + + + + + − + − + − *There are any number of arguments also we can give to find the <math> SUM </math>.+ − *SUM(-20..-10,11..20,30..50) − {{#ev:youtube|8iJutK_1nS4|280|center|Sum}} Line 24:
Line 26: − + − + Line 32:
Line 34: − + Line 38:
Line 40: − + Line 53:
Line 55: − +
no edit summary
==Description==
==Description==
*This function gives the calculation result of given formula.
*This function gives the calculation result of formula entered as a parameter.
*<math>Formula</math>
*<math>Formula</math> should be entered in double quotes as shown:
A=3;<br/>
B=4;<br/>
=CALC("A+B")
==ZOS==
==ZOS==
*The syntax is to calculate SUM is ZOS is <math>SUM(a,b,...)</math>
*The syntax to calculate any entered formula in ZOS is <math>CALC(Formula)</math>
*<math> a,b,..</math> are numbers to be added.
*<math>Formula</math> is any equation to be calculated.
==Examples==
==Examples==
| n2
| n2
| n3
| n3
| SUM
| Result
|- class="odd"
|- class="odd"
|SUM(1,2,3)
|CALC("MULT(1,2,3)")
| 1
| 1
| 2
| 2
| 6
| 6
|- class="even"
|- class="even"
| SUM(5,-9,45)
| CALC("ADD(5,-9,45)")
| 5
| 5
| -9
| -9
| 41
| 41
|- class="odd"
|- class="odd"
| SUM(A1:A3)
| CALC("SUM(A1:A3)")
| CELL A1
| CELL A1
| CELL A2
| CELL A2
==See also==
==See also==
*[[Manuals/calci/AVERAGE| AVERAGE]]
*[[Manuals/calci/AVERAGE| ADD]]
*[[Manuals/calci/PRODUCT| PRODUCT]]
*[[Manuals/calci/PRODUCT| PRODUCT]]