Here we can see that depending on how it is measured â that is, students missing 21, 20 days or 18 days, respectively -- that between one-fifth and one-third of students are not attending school regularly. Table 3 also begins to highlight the sheer magnitude of the challenge some school districts face.
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 (). Alternative with ISBLANK. Excel contains a function dedicated to testing for empty cells called ISBLANK. Excel Formula Training.
If you want to test a cell and take some action if the cell is blank (empty), you can use the IF function. In the example shown column D contains a date indicating when a task was 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 a value (a date in this case, but it could be any value) the formula assigns status of Closed. The formula in cell E5 is: