writer
2,661
edits
Changes
Jump to navigation
Jump to search
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..."
<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 ]]
*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 ]]