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

Lookup and Reference Examples

  • How to use Excel COLUMN Function
  • Count unique text values with criteria
  • Vlookup Examples in Excel
  • Last row number in range
  • How to get first column number in range in Excel

Data Analysis Examples

  • How to Create Area Chart in Excel
  • Conditional Formatting Color Scales Examples in Excel
  • How to create Gauge Chart in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • How to perform a t-Test in Excel

Data Validation Examples

  • Excel Data validation exists in list
  • Excel Data validation no punctuation
  • Excel Data validation must begin with
  • How To Create Drop-down List in Excel
  • Excel Data validation whole percentage only

If cell is blank in Excel

by

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

Formula

=IF(A1="","blank","not blank")

Explanation

To test a cell and take some action if the cell is blank (empty), you can use the IF function. The formula in cell E5 is:

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

How this formula works

The logical expression =”” means “is empty”. In the example shown, column D contains a date if a task has been completed. In column E, a formula checks for blank cells in column D. If a cell is blank, the result is a status of “Open”. If the cell contains value (a date in this case, but it could be any value) the formula returns “Closed”.

Worked Example:   How to set check register balance in Excel

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

Worked Example:   How to use Excel NOT Function

Display nothing if cell is blank

To display nothing if a cell is blank, you can replace the “value if false” argument in the IF function with an empty string (“”) like this:

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

Alternative with ISBLANK

Excel contains a function made to test for blank cells called ISBLANK. To use the ISBLANK, you can revise the formula as follows:

=IF(ISBLANK(D5),"Open","Closed")
Worked Example:   Conditional formatting column is blank in Excel

Post navigation

Previous Post:

if cell contains this or that in Excel

Next Post:

If cell equals 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
  • How to extract text between parentheses in Excel
  • Complete List of Excel Text Functions References and Examples
  • BAHTTEXT function: Description, Usage, Syntax, Examples and Explanation
  • Remove file extension from filename in Excel
  • How to calculate Number of Instances in Excel
  • Get days, hours, and minutes between dates in Excel
  • Check If Two Dates are same month in Excel
  • MONTH function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate next scheduled event in Excel
  • Sum through n months in Excel
  • DURATION function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate principal for given period in Excel
  • Calculate payment periods for loan in Excel
  • DDB function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate compound interest in Excel
Acronyms, Abbreviations, Initialism & What They Stand For
© 2022 xlsoffice . All Right Reserved. | Teal Smiles