Dashpivot offers the powerful logical formulas that help test whether a condition is true or false. These are one of the most common types of formulas to be used to automate your forms based on specific conditions. They can be used in simple data entry validation to even more complex analysis. These are the main uses of logical formulas:
Decision-making
Data Validation
Error Handling
Analysing Data
Filtering/Sorting Data
Automating Workflows
Complex Calculations
Dynamic Reporting
Make use of the logical formulas in Dashpivot to streamline your forms and make processes much easier to track.
Function ID | Description | Syntax | Sample | Results | Notes |
AND | Returns TRUE if all arguments are TRUE. | AND(Logicalvalue1, Logicalvalue2 ...Logicalvalue30) | =AND(A1=”Engineer”, B1=”Yes”) *A1 & B1 - list/text fields | Returns text, true |
|
FALSE | Returns the logical value FALSE. | FALSE() | =FALSE() | Returns text, false |
|
IF | Specifies a logical test to be performed. | IF(Test, Then value, Otherwisevalue) | =IF(A1>5, “Severe”, “Minor”) *A1 - Number/Text field Given that, A1 = 10 | Returns text, Severe |
|
IFS | Evaluates multiple logical tests and returns a value that corresponds to the first true condition. | IFS(Condition1, Value1[, Condition2, Value2[..., Condition_n, Value_n]]) | =IFS(A1>=80, “Pass”, A1<80, “Fail”) *A1 - Number/Text field Given that, A1 = 80 | Returns text, Pass |
|
IFNA | Returns the value if the cell does not contains the #N/A (value not available) error value, or the alternative value if it does. | IFNA(Value, Alternate_value) | =IFNA(1/0, "Division Error") | Returns text, Division error |
|
IFERROR | Returns the value if the cell does not contains an error value, or the alternative value if it does. | IFERROR(Value, Alternate_value) | =IFERROR(1/0, "Division Error") | Returns text, Division error |
|
NOT | Complements (inverts) a logical value. | NOT(Logicalvalue) | Ex. 1 =NOT(TRUE) _____ Ex. 2 =NOT(FALSE) | Ex. 1 Returns text, false _____ Ex. 2 Returns text, true |
|
SWITCH | Evaluates a list of arguments, consisting of an expression followed by a value. | SWITCH(Expression1, Value1[, Expression2, Value2[..., Expression_n, Value_n]], Otherwise_value) | =SWITCH(A1, 90, "A", 80, "B", "NO MATCH") *A1 - Text/Number field Given that, A1 = 85 | Returns text, “NO MATCH” (Because it is neither 90 nor 80.) |
|
OR | Returns TRUE if at least one argument is TRUE. | OR(Logicalvalue1, Logicalvalue2 ...Logicalvalue30) | =OR(A1 > 10, B1 < 5) *A1 & B1 - Number/Text fields Given that, A1 = 12 B1 = 6 | Returns text, true |
|
TRUE | The logical value is set to TRUE. | TRUE() | =TRUE() | Returns text, true |
|
XOR | Returns true if an odd number of arguments evaluates to TRUE. | XOR(Logicalvalue1, Logicalvalue2 ...Logicalvalue30) | =XOR(A1 > 10, B1 < 5) *A1 & B1 - Number/Text fields Given that, A1 = 9 B1 = 4 | Returns text, true (Because only either, meaning one of them is true. And one is an odd number.) |
|