Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.
this function will determine if there is an entry in particular cell
=ISBLANK(CellAddress) ie. =ISBLANK(A1). will return Boolean (True/False)
If A1 is blank result will be True, if it has some value result will be False
the ISBLANK function to test if a cell is empty or not
Use the ISBLANK function to test if a cell is empty or not.
For example, =ISBLANK(A1) will return TRUE if A1 is empty, and FALSE if A1 contains text a formula (even if the formula returns an empty string "").