SSuite Basic-Math Arithmetic Operators
Arithmetic operators are used to perform arithmetic between variables and/or values.
Given that y = 5, the table below explains the arithmetic operators:
| Operator | Description | Example | Result in y | Result in x |
|---|---|---|---|---|
| + | Addition | = y + 2 | y = 5 | x = 7 |
| - | Subtraction | = y - 2 | y = 5 | x = 3 |
| * | Multiplication | = y * 2 | y = 5 | x = 10 |
| / | Division | = y / 2 | y = 5 | x = 2.5 |
| % | Modulus (division remainder) | = y % 2 | y = 5 | x = 1 |
| ** | Exponent (standard =5^2 ) | = y ** 2 | y = 5 | x = 25 |
Please be aware that all methods are case sensitive. They must be entered exactly as described e.g. Math.PI , Math.ceil(x), Math.SQRT2
Take Note - Be aware that when using "Google Fonts", your spreadsheet will not be compatible with our Desktop spreadsheet software. Use only "System Fonts" if you wish to open, edit, or save your spreadsheets with our Desktop spreadsheet applications.
Google fonts are web based and are not compatible with Desktop software.
To use more advanced methods, use the following notation for each function:
=Math.ceil(4.4) // returns 5
=Math.floor(4.7) // returns 4
=Math.sin(90 * Math.PI / 180) // returns 1 (the sine of 90 degrees)
=Math.min(0, 150, 30, 20, -8, -200) // returns -200
=Math.random() // returns a random number
Example
Return a random number between 1 and 100:
=Math.floor((Math.random() * 100) + 1);
=Math.sqrt(16) // Returns the square root of 16
Number Methods
Example 1
=(100 + 23).toString(); // returns 123 from expression 100 + 23
Example 2
=9.656.toExponential(2) // returns 9.66e+0
=9.656.toExponential(4) // returns 9.6560e+0
=9.656.toExponential(6) // returns 9.656000e+0
Example 3
=9.656.toFixed(0) // returns 10
=9.656.toFixed(2) // returns 9.66
=9.656.toFixed(4) // returns 9.6560
=9.656.toFixed(6) // returns 9.656000
Example 4
=9.656.toPrecision() // returns 9.656
=9.656.toPrecision(2) // returns 9.7
=9.656.toPrecision(4) // returns 9.656
=9.656.toPrecision(6) // returns 9.65600
Example 5
=Boolean(10 > 9) // returns true = 1
=(10 > 9) // also returns true
=10 > 9 // also returns true
=Boolean(A4 > E8) // will return either 1 or 0 / True=1 False=0
Math Objects
Math.E // returns Euler's number
Math.PI // returns PI
Math.SQRT2 // returns the square root of 2
Math.SQRT1_2 // returns the square root of 1/2
Math.LN2 // returns the natural logarithm of 2
Math.LN10 // returns the natural logarithm of 10
Math.LOG2E // returns base 2 logarithm of E
Math.LOG10E // returns base 10 logarithm of E
Math Methods / Functions =Math.method( x )
| Method | Description |
|---|---|
| abs(x) | Returns the absolute value of x |
| acos(x) | Returns the arccosine of x, in radians |
| asin(x) | Returns the arcsine of x, in radians |
| atan(x) | Returns the arctangent of x as a numeric value between -PI/2 and PI/2 radians |
| atan2(y, x) | Returns the arctangent of the quotient of its arguments |
| ceil(x) | Returns the value of x rounded up to its nearest integer |
| cos(x) | Returns the cosine of x (x is in radians) |
| exp(x) | Returns the value of Ex |
| floor(x) | Returns the value of x rounded down to its nearest integer |
| log(x) | Returns the natural logarithm (base E) of x |
| max(x,y,...,n) | Returns the number with the highest value |
| min(x,y,...,n) | Returns the number with the lowest value |
| pow(x, y) | Returns the value of x to the power of y |
| random() | Returns a random number between 0 and 1 |
| round(x) | Returns the value of x rounded to its nearest integer |
| sin(x) | Returns the sine of x (x is in radians) |
| sqrt(x) | Returns the square root of x |
| tan(x) | Returns the tangent of an angle |
| trunc(x) | Returns the integer part of a number (x) |
| cbrt(x) | Returns the cubic root of a number (x) |
| tanh(x) | Returns the hyperbolic tangent of a number x |
| cosh(x) | Returns the hyperbolic cosine of a number x |
| atanh(x) | Returns the hyperbolic arctangent of a specified number x |
| asinh(x) | Returns the hyperbolic arcsine of a number x |
| acosh(x) | Returns the hyperbolic arccosine of a number x |
Bitwise Operators
| Operator | Name | Description |
|---|---|---|
| & | AND | Sets each bit to 1 if both bits are 1 |
| | | OR | Sets each bit to 1 if one of two bits is 1 |
| ^ | XOR | Sets each bit to 1 if only one of two bits is 1 |
| ~ | NOT | Inverts all the bits |
| << | Zero fill left shift | Shifts left by pushing zeros in from the right and let the leftmost bits fall off |
| >> | Signed right shift | Shifts right by pushing copies of the leftmost bit in from the left, and let the rightmost bits fall off |
| >>> | Zero fill right shift | Shifts right by pushing zeros in from the left, and let the rightmost bits fall off |
Examples of Bitwise Operations
| Operation | Result | Same as | Result |
|---|---|---|---|
| = 5 & 1 | 1 | 0101 & 0001 | 0001 |
| = 5 | 1 | 5 | 0101 | 0001 | 0101 |
| = ~ 5 | 10 (4bit unsigned) / -6 (32bit signed) |
~0101 | 1010 |
| = 5 << 1 | 10 | 0101 << 1 | 1010 |
| = 5 ^ 1 | 4 | 0101 ^ 0001 | 0100 |
| = 5 >> 1 | 2 | 0101 >> 1 | 0010 |
| = 5 >>> 1 | 2 | 0101 >>> 1 | 0010 |