Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Chart Axes in Excel
  • How To Remove Duplicates In Excel Column Or Row?
  • Number and Text Filters Examples in Excel
  • How to Create Thermometer Chart in Excel
  • How to create running total in an Excel Table

References

  • How to get last row in numeric data in Excel
  • Count rows that contain specific values in Excel
  • To count total rows in a range in Excel
  • How to use Excel ROW Function
  • Two-column Lookup in Excel

Data Validations

  • Excel Data validation don’t exceed total
  • Excel Data validation only dates between
  • Excel Data validation must begin with
  • Excel Data validation no punctuation
  • 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:   Count cells that contain numbers in Excel

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

Worked Example:   If cell equals 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")

Post navigation

Previous Post:

VLOOKUP without #N/A error 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

Logical Functions

  • How to return blank in place of #DIV/0! error in Excel
  • Nested IF function example in Excel
  • How to use Excel AND Function
  • IF function: Description, Usage, Syntax, Examples and Explanation
  • Complete List of Excel Logical Functions, References and Examples

Date Time

  • Get last day of month in Excel
  • Convert text date dd/mm/yy to mm/dd/yy in Excel
  • Display Days until expiration date in Excel
  • Get day name from date in Excel
  • How to get Weekdays, Working days between Two Dates in Excel

Grouping

  • If cell contains one of many things in Excel
  • How to randomly assign data to groups in Excel
  • Running count group by n size in Excel
  • Group times into 3 hour buckets in Excel
  • How to randomly assign people to groups in Excel

General

  • With vs Without Array Formula in Excel
  • List worksheet index numbers in Excel
  • How to Delete Cells, Row and Rows in Excel
  • Convert column number to letter in Excel
  • Zoom Worksheet in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning