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.
Use Excel's ISERROR function. The ISERROR function generally refers to cell references, not hard numbers. Say you want to find out if the range of cells A1:A14000 contains an error. Click your mouse on a blank cell and type the following formula: =ISERROR(A1:A14000).Don't put a period at the end of the function formula.Press Enter.. If Excel finds an error in this range of cells, it displays TRUE..ay you want to find out if the range of cells A1:A14000 contains an error. Click your mouse on a blank cell and type the following formula: =ISERROR(A1:A14000). Don't put a period at the end of the function formula. Press Enter.. If Excel finds an error in this range of cells, it displays TRUE..