or Explore Discussions

# Can Isblank be used for more than one cell?

04/21/21
Accepted

I want to show if a column/cell is blank. I've used the formula =IF(ISBLANK([Tutor Name]@row), "Not Complete", "Complete") It works for one cell/column, however I have a range of 5 cells/columns.

How do I connect the formula to return a Complete or Incomplete---all cells need to have data to return "Complete" and if any cell is blank the value should be "Not Complete".

Hi Charlene,

There is probably a simpler way to do this, but I would probably handle it this way:

=IF(AND(NOT(ISBLANK([Column1]@row)), NOT(ISBLANK([Column2]@row)), NOT(ISBLANK([Column3]@row)), NOT(ISBLANK([Column4]@row)), NOT(ISBLANK([Column5]@row))), "Complete", "Not Complete")

Try this out and let me know if it works. If it does, be sure to accept it as a solution so that others who may have a similar question can find the answer. And give me a vote up if I proved helpful. 👍

P.S. Keep in mind that if you ever add a Column6... etc. You will have to add those into the AND condition with the same NOT(ISBLANK(...)) test.

Edit: I have added a picture of a formatted formula so that you can better understand the logic of it.

• Try this:

=IF(AND(NOT(ISBLANK([Column1]@row)), NOT(ISBLANK([Column2]@row)), NOT(ISBLANK([Column3]@row)), NOT(ISBLANK([Column4]@row)), NOT(ISBLANK([Column5]@row))), "Complete", "Not Complete")

Hi Charlene,

There is probably a simpler way to do this, but I would probably handle it this way:

=IF(AND(NOT(ISBLANK([Column1]@row)), NOT(ISBLANK([Column2]@row)), NOT(ISBLANK([Column3]@row)), NOT(ISBLANK([Column4]@row)), NOT(ISBLANK([Column5]@row))), "Complete", "Not Complete")

Try this out and let me know if it works. If it does, be sure to accept it as a solution so that others who may have a similar question can find the answer. And give me a vote up if I proved helpful. 👍

P.S. Keep in mind that if you ever add a Column6... etc. You will have to add those into the AND condition with the same NOT(ISBLANK(...)) test.

Edit: I have added a picture of a formatted formula so that you can better understand the logic of it.

• I hope you're well and safe!

Here's another option. I prefer this structure because it's less to type. 😉

=IF(AND([Column1]@row <> ""; [Column2]@row <> ""; [Column3]@row <> ""; [Column4]@row <> ""; [Column5]@row <> ""); "Complete"; "Not Complete")

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD