WPS Tabular Information function

1.ERROR. TYPE

Purpose: Returns a number that corresponds to an error type, or returns #n/a if there are no errors. You can use Error.type to detect error values in the IF function and return text strings (such as "error occurred") to replace the error values.

Syntax: Error.type (Error code)

Parameter: Error code is an error type that needs to get its numeric code. Although the error code can be the actual error value, it is usually a cell reference, and the cell contains the formula you want to detect.

Note: The error code returned by the Error.type function is: #NULL! Returns 1, #DIV/0! returns 2, #VALUE! Returns 3, #REF! Returns 4, #NAME, returns 5, #NUM! Returns 6, and the other error returns #n/a.

Instance: If a5=36/0, then the formula "=error." TYPE (A5) "returns 2.

2.ISEVEN

Purpose: Test the parity of the parameters and return False if the parameter is even if it returns true.

Syntax: ISEVEN (value)

The numeric value to be tested. If the parameter value is not an integer, the subtotal is automatically truncated.

Note: This function must be loaded by the Analysis ToolPak before it can be used. If the argument number is not a numeric value, the ISEVEN function returns an error value of #value!.

Instance: the formula "=iseven (11) returns false" and =iseven (6) returns True.

3.ISODD

Purpose: Test the parity of the parameters, or False if the parameter is odd to return true.

Syntax: isodd (value)

Parameter: The value to be tested. If the argument is not an integer, the decimal part is automatically truncated.

Note: This function must be loaded by the Analysis ToolPak before it can be used.

Instance: the formula "=isodd (19)" returns True,=isodd (14.5) returns false.