Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to use ISBLANK function in MS EXCEL?

this function will determine if there is an entry in particular cell

LC MS Microsoft Office
user-image
Question added by Mohamed Mohideen Fazul Ansar , General Manager (GM) , Expolanka Freight (Pvt) Limited
Date Posted: 2014/05/26
Upvote (0) Views (11) Followers (4) Answers (4) Report Question
Write an Answer
Register now or log in to answer.
Atif Tanveer
by Atif Tanveer , Decision Support Specialist , Hamilton Health Science

=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

Ahmed Bassem Abd ElFattah Elsalhy
by Ahmed Bassem Abd ElFattah Elsalhy , Senior Sales , Kingsman whole sale accessories shop

the ISBLANK function to test if a cell is empty or not

Deleted user

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 "").

Bibin Elesa Philip
by Bibin Elesa Philip , Real Estate Property Management , The Gate Properties

It is use to find if a cell is empty or not.

Write Your Answer
More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.

Get Help