4D v18
ISBLANK
- 4D View Pro Reference
-
- 4D View Pro Formulas
-
- Operators and values
- Cell references
- Converting 4D View plug-in formulas
- ABS
- ACOS
- AND
- ASIN
- ATAN
- AVERAGE
- COLUMNLETTER
- COS
- COUNTA
- EXP
- FALSE
- FINDCELL
- FV
- IF
- INDIRECT
- ISBLANK
- LEN
- LN
- LOOKUP
- MAX
- MID
- MIN
- NOT
- NOW
- NPER
- OR
- PI
- PMT
- PV
- RAND
- RATE
- ROUND
- ROW
- RUNTIME_CURRENT_TIME
- RUNTIME_DATE
- RUNTIME_STRING
- RUNTIME_TIME
- RUNTIME_VIEW_STRING
- SIN
- SQRT
- STDEV.P
- SUBSTITUTE
- SUM
- TAN
- TEXT
- TODAY
- TRUE
- TYPE
- VAR.P
4D v18
ISBLANK
ISBLANK
| ISBLANK ( value ) | ||||||||
| Parameter | Type | Description | ||||||
| value | CellRef, Expression, Number, Text |
|
Value to evaluate | |||||
The ISBLANK function tests if the contents of a cell, a number, a text, or any expression, is empty. This function returns TRUE if the value refers to an empty cell or to no data.
Note: Cells containing an empty string ("") are considered as blank.
IF(ISBLANK(A1);”Error”;0) //"Error" if cell A1 is empty
ISBLANK(B1)
ISBLANK(A4-52)
ISBLANK(4) //FALSE
PROPERTIES
Product: 4D
Theme: 4D View Pro Formulas
HISTORY
ARTICLE USAGE
4D View Pro Reference ( 4D v18)
© 1985-2020 4D SAS / 4D, Inc. All rights reserved.