Dashpivot offers formulas that perform a variety of tasks from simple calculations to advanced data analysis. These are the main uses of operator formulas:
Arithmetic operations
Comparisons
Logical Operations
Make use of the operator formulas in Dashpivot to streamline your forms and make processes much easier to track.
Function ID | Description | Syntax | Sample | Results | Notes |
HF.ADD | Adds two values. | HF.ADD(Number, Number) | =HF.ADD(A1, B1) *A1 & B1 - Number fields Given that, A1 = 2 A2 = 3 | Returns value, 5 |
|
HF.DIVIDE | Divides two values. | HF.DIVIDE(Number, Number) | =HF.DIVIDE(A1,B1) *A1 & B1 - Number fields Given that, A1 = 10 B1 = 5 | Returns value, 2 |
|
HF.EQ | Tests two values for equality. | HF.EQ(Value, Value) | =HF.EQ(A1, B1) *A1 & B1 - All fields except prefilled Given that, A1 = “Yes” B1 = “No” | Returns value, “false” | With A1 = ““ and B1 = ““, value returns TRUE. For non-numbers or texts, cells are not case sensitive. |
HF.LTE | Tests two values for less-equal relation. | HF.LEQ(Value1, Value2) | =HF.LTE(A1, B1) *A1 & B1 - Number fields Given that, A1 = 10 B1 = 2 | Returns value, “false” (Because A1 > B1) | If Value1 <= Value 2, test is TRUE If Value1 >= Value 2, test is FALSE |
Tests two values for less-than relation. | HF.LT(Value, Value) | =HF.LT(A1, B1) *A1 & B1 - Number fields Given that, A1 = 10 B1 = 2 | Returns value, “false” (Because A1 > B1) | If Value1 <= Value 2, test is TRUE If Value1 >= Value 2, test is FALSE | |
HF.GTE | Tests two values for greater-equal relation. | HF.GEQ(Value, Value) | =HF.GTE(A1, B1) *A1 & B1 - Number fields Given that, A1 = 15 B1 = 9 | Returns value, “true” (Because A1 > B1) | If Value1 >= Value 2, test is TRUE If Value1 <= Value 2, test is FALSE |
HF.MINUS | Subtracts two values. | HF.MINUS(Number, Number) | =HF.MINUS (A1, B1) *A1 & B1 - Number fields Given that, A1 = 50 B1 = 18 | Returns value, 32 |
|
HF.MULTIPLY | Multiplies two values. | HF.MULTIPLY(Number, Number) | =HF.MULTIPLY(A1, B1) *A1 & B1 - Number fields Given that, A1 = 22 B1 = 19 | Returns value, 418 |
|
Tests two values for inequality. | HF.NE(Value, Value) | =HF.EQ(A1, B1) *A1 & B1 - All fields except prefilled Given that, A1 = “Yes” B1 = “No” | Returns value, “true” | With A1 = ““ and B1 = ““, value returns FALSE. For non-numbers or texts, cells are not case sensitive. | |
HF.POW | Computes power of two values. | HF.POW(Number, Power) | =HF.POW(A1, 2) *A1 - Number field Given that, A1 = 10 | Returns value, 100 | Power field should be included in the formula and cannot be cell-referenced. |