Giraffe includes common functions found in most desktop spreadsheet programs.
The syntax may be slightly different for some functions you’re used to, so check out the instructions in the list below. You can use these functions in Formulas to make calculations out of Properties referenced in components
Operand | Description |
- | subtraction |
-x | Negation |
; | Expression separator |
! | Factorial. Factorial, in mathematics, the product of all positive integers less than or equal to a given positive integer and denoted by that integer and an exclamation point. Thus, factorial seven is written 7!, meaning 1 × 2 × 3 × 4 × 5 × 6 × 7. |
!= | Logical not equal to. Add != to an if statement to test if a variable does not equal a value |
(...) | Grouping for order of operations. Use parenthesis to group expressions to control order of operations. Order of operations is the rule that tells us the sequence in which we should solve an expression with multiple operations |
* | multiplication |
/ | division |
% | remainder. Calculate the remainder of a division operand |
^ | Exponentiation. The exponent of a number says how many times to use the number in a multiplication. I.E. 8^2 = 8 to the Power 2 = 8*8 |
+ | Addition |
+x | Unary plus. This converts its operand to a number, but has no other effect. |
<= | Less than or equal to. Add <= to an if statement to test if a variable is less than or equals a value |
= | Override variable value |
== | Logical equal to. Add == to an if statement to test if a variable equals a value |
>= | Greater than or equal to. Add >= to an if statement to test if a variable is greater than or equals a value |
abs(x) | Absolute value (magnitude) of x. In mathematics, the absolute value is the non-negative value of without regard to its sign. |
acos(x) | Arc cosine of x (in radians) |
acosh(x) | Hyperbolic arc cosine of x (in radians) |
and | Logical and. Add and to a logical if statement to require multiple values to test true for a true result |
asin(x) | Arc sine of x (in radians) |
asinh(x) | Hyperbolic arc sine of x (in radians) |
atan(x) | Arc tangent of x (in radians) |
atanh(x) | Hyperbolic arc tangent of x (in radians) |
cbrt(x) | Cube root of x |
ceil(x) | Ceiling of x — the smallest integer that’s >= x |
cos(x) | Cosine of x (x is in radians) |
cosh(x) | Hyperbolic cosine of x (x is in radians) |
exp(x) | e^x (exponential/antilogarithm function with base e) |
expm1(x) | e^x - 1 |
floor(x) | Floor of x — the largest integer that’s <= x |
int(x) | Rounds to the nearest integer |
inverse(x) | undoes the operation of x |
ln(x) | Natural logarithm of x |
log(x) | Natural logarithm of x (synonym for ln, not base-10) |
log1p(x) | Natural logarithm of (1 + x) |
log2(x) | Base-2 logarithm of x |
log10(x) | Base-10 logarithm of x |
or | Logical or. Add or to a logical if statement to test more than one value for true |
PI | π |
round(x) | X, rounded to the nearest integer, using "grade-school rounding" If the decimal is less than .5 it will round down. If the decimal is greater than or equal to .5, it will round up. |
sign(x) | Sign of x (-1, 0, or 1 for negative, zero, or positive respectively) |
sin(x) | Sine of x (x is in radians) |
sinh(x) | Hyperbolic sine of x (x is in radians) |
sqrt(x) | Square root of x. Result is NaN (Not a Number) if x is negative. |
tan(x) | Tangent of x (x is in radians) |
tanh(x) | Hyperbolic tangent of x (x is in radians) |
trunc(x) | Integral part of a X, looks like floor(x) unless for negative number |
x ? y : z | Ternary conditional (if x then y else z). Perform a logical If statement.
x = test (IE is A greater than B?) ? = separator y = result if true : separator z = result if false |
x! | Factorial (x * (x-1) * (x-2) * … * 2 * 1). gamma(x + 1) for non-integers. |