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
- Comparison Operators in Google Sheets and Equivalent Functionsinfoinspired.com
- Use conditional formatting rules in Google Sheets - Computer - Google Docs Editors Helpsupport.google.com
- Write DAX formulas - Training | Microsoft Learndocs.microsoft.com
- Introduction - Trainingdocs.microsoft.com
- AVERAGE - Google Docs Editors Helpsupport.google.com
- GitHub - Experience-Monks/math-as-code: a cheat-sheet for mathematical notation in code formgithub.com
- First-order logic - Wikipediaen.wikipedia.org
- Scientists rename human genes to stop Microsoft Excel from misreading them as dates | The Vergetheverge.com
- Udacity AB Testing by Google | Kagglekaggle.com
- Create a Comparison Chart Online (Free Examples) | Canvacanva.com
- List of logic symbols - Wikipediaen.wikipedia.org