Share via


WorksheetFunction.IsEven Method

Checks the type of value and returns true or false depending if the value is even.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function IsEven ( _
    Arg1 As Object _
) As Boolean
'Usage
Dim instance As WorksheetFunction
Dim Arg1 As Object
Dim returnValue As Boolean

returnValue = instance.IsEven(Arg1)
bool IsEven(
    Object Arg1
)

Parameters

  • Arg1
    Type: System.Object

    Value - 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.

See Also

Reference

WorksheetFunction Interface

WorksheetFunction Members

Microsoft.Office.Interop.Excel Namespace