Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to create dynamic named range with OFFSET in Excel
  • Vlookup Examples in Excel
  • Two-way lookup with VLOOKUP in Excel
  • Extract data with helper column in Excel
  • How to use Excel COLUMN Function

Data Analysis Examples

  • How to create Checklist in Excel
  • Error Bars in Excel
  • How to Sort by Color in Excel
  • Example of COUNTIFS with variable table column in Excel
  • What-If Analysis: Scenarios and Goal Seek in Excel

Data Validation Examples

  • Excel Data validation exists in list
  • Excel Data validation unique values only
  • Excel Data validation whole percentage only
  • Excel Data validation allow weekday only
  • Excel Data validation must contain specific text

If cell is not blank in Excel

by

This tutorial shows how to calculate If cell is not blank in Excel using the example below;

Formula

=IF(A1<>"","Not blank","Blank")

Explanation

If you want to test a cell and take some action if the cell is not blank (not empty), you can use a simple formula based on the IF function.

In the example shown, we have a simple task list with a date complete in column D. In column E, we have a formula that checks cells in column D to see if they are empty or not. When a cell is blank, the formula assigns a status of “Open”. If the cell contains a value (a date in this case, but it could be anything) the formula will assign a status of “Closed”. The formula in cell E5 is:

=IF(D5<>"","Closed","Open")

The <> is a logical operator that means “not equal to”.

Worked Example:   If cell is this OR that in Excel

The effect of showing “Closed” in light gray is accomplished with a conditional formatting rule.

Worked Example:   If cell is blank in Excel

Display nothing if cell is not blank

If you only want to display a value if a cell is not blank, you can replace the “value if false” argument in the IF function with an empty string (“”). The formula would then be:

=IF(D5<>"","Closed","")

Alternative with ISBLANK

Excel contains a function dedicated to testing for empty cells called ISBLANK. To use the ISBLANK function in this case, instead of the A1<>”” syntax, you would wrap ISBLANK inside the NOT function like this:

=IF(NOT(ISBLANK(D5)),"Closed","Open")
Worked Example:   If this AND that in Excel

Post navigation

Previous Post:

If cell is greater than in Excel

Next Post:

If cell is this OR that in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Remove leading and trailing spaces from text in one or more cells in Excel
  • How to use double quotes inside a formula in Excel
  • How to create email address with name and domain in Excel
  • How to get top level domain (TLD) in Excel
  • DBCS function: Description, Usage, Syntax, Examples and Explanation
  • Get last day of month in Excel
  • How to calculate months between dates in Excel
  • Sum through n months in Excel
  • Calculate years between dates in Excel
  • Get date from day number in Excel
  • ACCRINTM function: Description, Usage, Syntax, Examples and Explanation
  • ISPMT function: Description, Usage, Syntax, Examples and Explanation
  • TBILLYIELD function: Description, Usage, Syntax, Examples and Explanation
  • COUPDAYSNC function: Description, Usage, Syntax, Examples and Explanation
  • NOMINAL function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles