=ISTRUE
The ISTRUE function evaluates a semicolon list of values and returns true if all the values in the list are true. Otherwise, the function returns false if any value in the list is false. Any number greater than 0 will be evaluated as true, so numbers can be evaluated as well.
The ISTRUE Function is formatted as follows:
Syntax
Section titled “Syntax”=ISTRUE(IsThisTrue; OptionalIsThisTrue; OptionalIsThisAlsoTrue; etc)Parameters
Section titled “Parameters”-
IsThisTrue – The value to evaluate.
-
OptionalIsThisTrue; … – One or more additional values to evaluate, each separated by a semicolon.
How It Works
Section titled “How It Works”-
Evaluates each value in the list.
-
Returns 1 (true) only if every value is true.
-
Returns 0 (false) if any value is false or not recognized as true.
-
Values recognized as true include 1, true, t, and any number greater than 0.
Example
Section titled “Example”=ISTRUE(1; true; 25)Returns
1 (all three values evaluate to true)
Note: Formula functions are case sensitive and must be in all caps.