Difference between revisions of "Manuals/calci/CALC"

Latest revision as of 03:41, 3 April 2017

CALC(Formula)

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

@@ Line 5: / Line 5: @@
 ==Description==
-*This function gives the calculation result of given formula.
+*This function gives the calculation result of formula entered as a parameter.
-*<math>Formula</math>
+*<math>Formula</math> should be entered in double quotes as shown:
+A=3;<br/>
+B=4;<br/>
+=CALC("A+B")
 ==ZOS==
-*The syntax is to calculate SUM is ZOS is <math>SUM(a,b,...)</math>
+*The syntax to calculate any entered formula in ZOS is <math>CALC(Formula)</math>
-*<math> a,b,..</math> are numbers to be added.
+*<math>Formula</math> is any equation to be calculated.
-*There are any number of arguments also we can give to find the <math> SUM </math>.
-*SUM(-20..-10,11..20,30..50)
-{{#ev:youtube|8iJutK_1nS4|280|center|Sum}}
 ==Examples==
@@ Line 24: / Line 26: @@
 | n2
 | n3
-| SUM
+| Result
 |- class="odd"
-|SUM(1,2,3)
+|CALC("PRODUCT(1,2,3)")
 | 1
 | 2
@@ Line 32: / Line 34: @@
 | 6
 |- class="even"
-| SUM(5,-9,45)
+| CALC("ADD(5,-9,45)")
 | 5
 | -9
@@ Line 38: / Line 40: @@
 | 41
 |- class="odd"
-| SUM(A1:A3)
+| CALC("SUM(A1:A3)")
 | CELL A1
 | CELL A2
@@ Line 53: / Line 55: @@
 ==See also==
-*[[Manuals/calci/AVERAGE| AVERAGE]]
+*[[Manuals/calci/CALCULATE| CALCULATE]]
+*[[Manuals/calci/ADD| ADD]]
 *[[Manuals/calci/PRODUCT| PRODUCT]]