Difference between revisions of "Manuals/calci/CALCULATE"

From ZCubes Wiki
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...")
 
 
(One intermediate revision by one other user not shown)
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
 
| 6
 
|- class="even"
 
|- class="even"
| CALCULATE("5+(-9)+45")
+
| CALCULATE("SUM(5,-9,45)")
 
| 5
 
| 5
 
| -9
 
| -9
 
| 45
 
| 45
 
| 41
 
| 41
|- class="odd"
+
|-
| CALCULATE("A1+A2+A3")
 
| CELL A1                       
 
| CELL A2
 
| CELL A3
 
| A1+A2+A3
 
|- class="even"
 
  
 
|}
 
|}

Latest revision as of 21:25, 12 February 2020

CALCULATE(String)

  • where is the string equation to calculate.

Description

  • This function gives the calculation result of string entered as a parameter.
  • should be entered in double quotes as shown:

A=3;
B=4;
=CALCULATE("A+B")


ZOS

  • The syntax to calculate any entered formula in ZOS is
  • is any equation to be calculated.


Examples

Equation n1 n2 n3 Result
CALCULATE("1+2+3") 1 2 3 6
CALCULATE("SUM(5,-9,45)") 5 -9 45 41

Related Videos

SUM

See also

References

SUM