The ISBLANK function returns true for values that are blank.
For example, you can use the ISBLANK function to determine if an employee has an active health plan.
Syntax
ISBLANK(Value to test)
Arguments
| Argument | Data type | Description |
| Value to test | Date, time period, text, or list | The value to test for blankness. |
The ISBLANK function returns a Boolean result.
Calculation engine functionality differences
In Polaris, the ISBLANK function considers a text value that consists exclusively of carriage return characters to be a blank value.
In the Classic Engine, the ISBLANK function considers a carriage return to be a non-blank value.
Syntax example
ISBLANK(Health Plan Start Date)
In this example, Health Plan Start Date is a line item with a date format. This function returns true if a value from the line item is empty, which means there is no Health Plan Start Date on record.
Excel equivalent function
Examples
In this example, Health Plan Start Date source is period-formatted, using ISBLANK (Health Plan Start Date) will return a boolean value of true if Health Plan Start Date is blank, and false if the value is anything else.
| Jan 2021 | Feb 2021 | Mar 2021 | Q1 FY21 | |
| Health Coverage Points | 75 | 98 | 115 | 288 |
| Health Plan | Single | |||
| Employee Deduction (%Salary) | 0 | 0 | 3.5 | |
| Health Plan Start Date | Mar 2021 | |||
ISBLANK (Health Plan Start Date) |
