What it does: The ISBLANK() Function returns a boolean result – whether or not the cell is blank.
Plain English: This formula let’s you know if the cell in question is blank. This is useful because if you’re dealing with hundreds or thousands of rows of data, you may need to handle blank values separately. What if 21 out of 365 days of the year show blank data?
- Why are the cells blank?
- Where did the error occur?
The ISBLANK() formula is often used in conjunction with an IF() formula to write conditional arguments.
- Cell – the cell you want to check
Blog Posts using ISBLANK(cell)
Videos using ISBLANK()
What it does: The ISNUMBER() function checks to see whether the given argument is a number.
Plain English: The ISNUMBER literally tests to see if a given value is a number. The function is very useful to test the results of other functions whose results may or may not be numbers. For instance, FIND(), MATCH(), SEARCH(), and many other excel functions can return a numeric value. Often times, what is more important is not so much the number spat out of these equations, but whether or not they return a number at all.
- Value – The value you want to check. The result is a Boolean value – either TRUE or FALSE.
Blog Posts using ISNUMBER()
Videos using ISNUMBER()