INPBLANKRC Function

The INPBLANKRC function returns a value based on whether or not a paragraph in a table is blank. The paragraph that is tested must be in the same row as the current position and the column to be tested is specified in the function call.

The function returns the value of 1 if the paragraph is blank, and 0 if not.

If the offset entered does not resolve to a valid column in the table, this function returns 1.

Syntax

INPBLANK(columnOffset)

The value specified for columnOffset must be an integer.

Positive integers specify columns to the right of the current position.

Negative integers specify columns to the left of the current position.

Example 1

Entering INPBLANKRC(1) in row 1, column 2 of a table returns whether or not row 1, column 3 is blank.

Example 2

Entering INPBLANKRC(-3) in row 1, column 1 of a table returns 1 since row 1, column -2 is not a valid column reference.

Related Topics

• Miscellaneous Functions