**CONCEPT:**

This is again a part of the conditional assessment.

What if we want to know whether the cell contains a number or the text.

Well , it is very easy because Excel provides us with a direct function for the same. Or even if there were no function, we would have done it by playing with the codes.

FUNCTIONS ARE ALSO MADE FROM THE BASIC ENTITIES OF ANY PROGRAMMING LANGUAGE. IF WE KNOW THE BASICS, WE CAN CREATE OUR OWN FUNCTION.

Let us take an example and check if the cell contains a number or the Text.

So we have direct functions ISNUMBER() and ISTEXT().

If ISNUMBER(CELL CONTAINING VALUE)=TRUE that means the cell contains the number.

If ISTEXT(CELL CONTAINING VALUE)=TRUE that means the cell contains the TEXT.

**EXAMPLES:**

Let us take an example.

Suppose a column is there with a mix of text and numbers.

Let us check first, whether the cell contains a number and in the next column let us check if the cell contains text.

VALUES |

WHAT |

12 |

65 |

HELLO |

GYANKOSH.NET |

STEPS TO USE ISNUMBER OR ISTEXT.

- Select the cell where we want to get the output.
- Put the formula as =ISNUMBER(CELL CONTAINING THE VALUE) to check if the value is a number.
- Similarly put the formula as =ISTEXT(CELL CONTAINING THE VALUE) to check if the value is a Text.
- The result will be displayed as TRUE or FALSE.