Difference between revisions of "Manuals/calci/CALC"
Jump to navigation
Jump to search
| Line 28: | Line 28: | ||
| Result | | Result | ||
|- class="odd" | |- class="odd" | ||
| − | |CALC(" | + | |CALC("PRODUCT(1,2,3)") |
| 1 | | 1 | ||
| 2 | | 2 | ||
| Line 55: | Line 55: | ||
==See also== | ==See also== | ||
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/CALCULATE| CALCULATE]] |
| + | *[[Manuals/calci/ADD| ADD]] | ||
*[[Manuals/calci/PRODUCT| PRODUCT]] | *[[Manuals/calci/PRODUCT| PRODUCT]] | ||
Latest revision as of 03:41, 3 April 2017
CALC(Formula)
- where is the formula of any calculation to be performed.
is the formula of any calculation to be performed.Description
- This function gives the calculation result of formula entered as a parameter.
- should be entered in double quotes as shown:
A=3;
B=4;
=CALC("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 |
|---|---|---|---|---|
| CALC("PRODUCT(1,2,3)") | 1 | 2 | 3 | 6 |
| CALC("ADD(5,-9,45)") | 5 | -9 | 45 | 41 |
| CALC("SUM(A1:A3)") | CELL A1 | CELL A2 | CELL A3 | A1+A2+A3 |
Related Videos
See also
References