Manuals/calci/CALCULATE - Revision history

Joseph at 03:25, 13 February 2020

2020-02-13T03:25:02Z

Swapna: /* Examples */

2017-04-03T09:48:25Z

Examples

Swapna: Created page with "
'''CALCULATE(String)'''

where $String$ is the string equation to calculate. ==Description== This function gives the calc..."

2017-04-01T11:01:35Z

Created page with "<div style="font-size:30px">'''CALCULATE(String)'''</div><br/> *where <math>String</math> is the string equation to calculate. ==Description== *This function gives the calc..."

New page

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

*where <math>String</math> is the string equation to calculate.

==Description==

*This function gives the calculation result of string entered as a parameter.
*<math>String</math> should be entered in double quotes as shown:
A=3;<br/>
B=4;<br/>
=CALCULATE("A+B")

==ZOS==

*The syntax to calculate any entered formula in ZOS is <math>CALCULATE(String)</math>
*<math>String</math> is any equation to be calculated.

==Examples==

{| id="TABLE3" class="SpreadSheet blue"
|- class="even"
!Equation
| n1
| n2
| n3
| Result
|- class="odd"
|CALCULATE("1+2+3")
| 1
| 2
| 3
| 6
|- class="even"
| CALCULATE("5+(-9)+45")
| 5
| -9
| 45
| 41
|- class="odd"
| CALCULATE("A1+A2+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| CALC]]
*[[Manuals/calci/PRODUCT| ADD]]

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

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

*[[ Z3 | Z3 home ]]

← Older revision		Revision as of 03:25, 13 February 2020
Line 1:		Line 1:
−	~~<div style~~=~~"font-size:30px">'''~~CALCULATE(String)~~'''</div><br/>~~	+	=CALCULATE(String)=

	*where <math>String</math> is the string equation to calculate.		*where <math>String</math> is the string equation to calculate.

@@ Line 34: / Line 34: @@
 | 6
 |- class="even"
-| CALCULATE("5+(-9)+45")
+| CALCULATE("SUM(5,-9,45)")
 | 5
 | -9
 | 45
 | 41
-|- class="odd"
+|-
 |}

Manuals/calci/CALCULATE - Revision history

Joseph at 03:25, 13 February 2020

Swapna: /* Examples */

Swapna: Created page with "'''CALCULATE(String)''' *where String is the string equation to calculate. ==Description== *This function gives the calc..."

Swapna: Created page with "
'''CALCULATE(String)'''

where $String$ is the string equation to calculate. ==Description== This function gives the calc..."