ISNUMBER and IF formula example
Let’s see an example of the ISNUMBER and IF function 🤓
We have the following example data.
We want to find the salary of an employee in row 6 in the given data set.
But we want to keep the data private. To do that, we have used the IF function that will return the salary amount only if we use ID No.
If anyone tries to find the salary using names, the function will return an empty cell value.
The ISNUMBER function becomes important here as it checks if the given cell value is a number. If the selected cell is not a number, it will return a blank cell.
Let’s see this in action now, shall we? 👀
- Select a cell.
- Apply the formula as:
- Add the ISNUMBER formula and cell value to check.
- Enter the value_if_true and value_if_false arguments as:
=IF(ISNUMBER(A6), C6, ” “)
And tada! Excel returns the expected result.
That’s because cell A6 contains a number, and we get the score corresponding to that ID No.
If we had used a cell reference containing a text string, for instance, cell B6, the function would return a blank cell. See the image below for reference.
As expected, we get an empty cell because cell B6 contains a text string.
Pretty simple, no? 😉