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.
The next step is to create a formula that will copy the value from the first heading above each blank cell. 1  With the blank cells selected, type an equal sign, to start the formula. 2  On the keyboard, press the up arrow. 3  This enters a reference to the cell above cell A2 in this example.elect the Empty Cells. To select the empty cells, use Excel's built in Go To Special feature: 1  Select columns A and B, that contain the blank cells. 2  On the Ribbon's Home tab, click Find & Select. 3  Click Go To Special.