Description
ISLOGICAL Function is a conditional function that returns either TRUE or FALSE as result. Thus if the condition is met, Excel returns the TRUE result otherwise it returns the text FALSE.
Conditional functions play a major role in dynamic Excel modeling as these provide the opportunity to vary results if the particular scenario changes.
Logical Value means TRUE or FALSE text, either written or returned from a function.
In ISLOGICAL if the referred cell contains a logical value, it means the condition is met and the TRUE result will be returned. Similarly, if the value is the referred cell is not a logical value, Excel will return “FALSE” as a result.
Remember, if the provided syntax is not a reference to any cell, Excel will return the #NAME error.
=ISLOGICAL(value)
The ISLOGICAL function’s syntax has the following argument:
- value Required
The value is the cell reference that you want to test against the condition if the cell contains a logical value (TRUE/ FALSE). The value argument can be a blank (empty cell), error, logical value, number, or reference value, etc.
