ISBLANK

This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com

Home

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

Home

4D v19

4D View Pro Reference

4D View Pro Formulas

ISBLANK


ISBLANK ( value )

Parameter	Type	Description
value	CellRef, Expression, Number, Text	Value to evaluate

Description

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.

Example

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

PAGE CONTENTS

Description

Example

HISTORY

ARTICLE USAGE

4D View Pro Reference ( 4D v19)

Add a comment