WorksheetFunction.IsLogical Method
Checks the type of value and returns true or false depending if the value refers to a logical value.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Function IsLogical ( _
Arg1 As Object _
) As Boolean
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Object
Dim returnValue As Boolean
returnValue = instance.IsLogical(Arg1)
bool IsLogical(
Object Arg1
)
Parameters
Arg1
Type: System.ObjectValue - the value you want tested. Value can be a blank (empty cell), error, logical, text, number, or reference value, or a name referring to any of these, that you want to test.
Return Value
Type: System.Boolean
Remarks
The value arguments of the IS functions are not converted. For example, in most other functions where a number is required, the text value "19" is converted to the number 19. However, in the formula ISNUMBER("19"), "19" is not converted from a text value, and the IsNumber(Object) function returns false.
The IS functions are useful in formulas for testing the outcome of a calculation. When combined with the IF function, they provide a method for locating errors in formulas.