Changes

1,100 bytes added , 11:01, 1 April 2017

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 ]]

Swapna

writer

2,661

edits

Changes

Manuals/calci/CALCULATE (view source)

Revision as of 11:01, 1 April 2017