Excel formula: If cell is not blank | Exceljet
In this example, column D records the date a task was completed. Therefore, if the column contains a date (i.e. is not blank), we can assume the task is complete. The formula in cell E5 uses the IF function to check if D5 is "not empty".
Summary To test if a cell is not blank (i.e. has content), you can use a formula based on the IF function . In the example shown, the formula in cell E5 is: =IF(D5<>"","Done","") As the formula is copied down it returns "Done" when a cell in column D is not blank and an empty string ("") if the cell is blank. Generic formula =IF(A1<>"","not blank","blank") Explanation The goal is to create a formula that returns "Done" in column E when a cell in column D is not blank (i.e., contains a value). In the worksheet shown, column D records the date a ta
related reading
- Count cells that contain text - Excel formula | Exceljetexceljet.net
- Use conditional formatting rules in Google Sheets - Computer - Google Docs Editors Helpsupport.google.com
- Write DAX formulas - Training | Microsoft Learndocs.microsoft.com
- Comparison Operators in Google Sheets and Equivalent Functionsinfoinspired.com
- Basic Syntax | Markdown Guidemarkdownguide.org
- Introduction - Trainingdocs.microsoft.com
- GitHub - Experience-Monks/math-as-code: a cheat-sheet for mathematical notation in code formgithub.com
- Use Checkboxes in Google Sheets to Toggle Numbers in or out of a calculationyoutube.com
- AVERAGE - Google Docs Editors Helpsupport.google.com
- Japanese Conditional Form ならtofugu.com
- 3. Logic - Mathematics in Lean v4.19.0 documentationleanprover-community.github.io
- GitHub - dragonman225/notablog: Tell stories of your work with Notiongithub.com