Manuals/calci/CALC - Revision history

Swapna at 09:41, 3 April 2017

2017-04-03T09:41:45Z

Swapna at 10:49, 1 April 2017

2017-04-01T10:49:09Z

Swapna: Created page with "
'''CALC(Formula)'''

where $Formula$ is the formula of any calculation to be performed. ==Description== This function giv..."

2017-04-01T02:12:52Z

Created page with "<div style="font-size:30px">'''CALC(Formula)'''</div><br/> *where <math>Formula</math> is the formula of any calculation to be performed. ==Description== *This function giv..."

New page

<div style="font-size:30px">'''CALC(Formula)'''</div><br/>

*where <math>Formula</math> is the formula of any calculation to be performed.

==Description==

*This function gives the calculation result of given formula.
*<math>Formula</math>

==ZOS==

*The syntax is to calculate SUM is ZOS is <math>SUM(a,b,...)</math>
*<math> a,b,..</math> are numbers to be added.
*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}}

==Examples==

{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
!Equation
| n1
| n2
| n3
| SUM
|- class="odd"
|SUM(1,2,3)
| 1
| 2
| 3
| 6
|- class="even"
| SUM(5,-9,45)
| 5
| -9
| 45
| 41
|- class="odd"
| SUM(A1:A3)
| CELL A1
| CELL A2
| CELL A3
| A1+A2+A3
|- class="even"

|}

==Related Videos==

{{#ev:youtube|04qw5hmXojw|280|center|SUM}}

==See also==

*[[Manuals/calci/AVERAGE| AVERAGE]]
*[[Manuals/calci/PRODUCT| PRODUCT]]

==References==
[http://en.wikipedia.org/wiki/Summation SUM]

*[[Z_API_Functions | List of Main Z Functions]]

*[[ Z3 | Z3 home ]]

@@ Line 28: / Line 28: @@
 | Result
 |- class="odd"
-|CALC("MULT(1,2,3)")
+|CALC("PRODUCT(1,2,3)")
 | 1
 | 2
@@ Line 55: / Line 55: @@
 ==See also==
-*[[Manuals/calci/AVERAGE| ADD]]
+*[[Manuals/calci/CALCULATE| CALCULATE]]
 *[[Manuals/calci/PRODUCT| PRODUCT]]

@@ Line 5: / Line 5: @@
 ==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:
 ==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.
-*There are any number of arguments also we can give to find the <math> SUM </math>.
 ==Examples==
@@ Line 24: / Line 26: @@
 | n2
 | n3
-| SUM
+| Result
 |- class="odd"
-|SUM(1,2,3)
+|CALC("MULT(1,2,3)")
 | 1
 | 2
@@ Line 32: / Line 34: @@
 | 6
 |- class="even"
-| SUM(5,-9,45)
+| CALC("ADD(5,-9,45)")
 | 5
 | -9
@@ Line 38: / Line 40: @@
 | 41
 |- class="odd"
-| SUM(A1:A3)
+| CALC("SUM(A1:A3)")
 | CELL A1
 | CELL A2
@@ Line 53: / Line 55: @@
 ==See also==
-*[[Manuals/calci/AVERAGE| AVERAGE]]
+*[[Manuals/calci/AVERAGE| ADD]]
 *[[Manuals/calci/PRODUCT| PRODUCT]]

Manuals/calci/CALC - Revision history

Swapna at 09:41, 3 April 2017

Swapna at 10:49, 1 April 2017

Swapna: Created page with "'''CALC(Formula)''' *where Formula is the formula of any calculation to be performed. ==Description== *This function giv..."

Swapna: Created page with "
'''CALC(Formula)'''

where $Formula$ is the formula of any calculation to be performed. ==Description== This function giv..."