Microsoft Office Tutorials and References

In Depth Information

**Getting to Know Your Type**

ISTEXT returns True when a cell contains any type of text. ISNONTEXT

returns True when a cell contains anything that is not text, including

numbers, dates, and times. The ISNONTEXT function also returns True if the cell

contains an error.

The ISNUMBER function returns True when a cell contains a number, which

can be an actual number or a number resulting from evaluation of a formula

in the cell. You can use ISNUMBER as an aid to help data entry. Say you

designed a worksheet that people fill out. One of the questions is age. Most

people would enter a numeric value such as 18, 25, 70, and so on. But

someone could type in the age as text, such as eighteen, thirty-two, or “none of

your business.” An adjacent cell could use ISNUMBER to return a message

about entering the numeric age. The formula would look something like this:

=IF(ISNUMBER(B3),””,”Please enter your age as a number”)

Here’s how to use any of the IS functions:

1. Position the cursor in the cell where you want the results to appear.

2. Enter one of the IS functions.

For example, enter
=ISTEXT(
to begin the function entry.

3. Enter a cell address.

4. Enter a
), and press Enter.

The result is always either True or False.

Getting to Know Your Type

The TYPE function tells you what the type of the information is. Possible

types follow:

✓
Number

✓
Text

✓
A logical value

✓
An error

✓
An array

In all cases TYPE returns a number:

✓
1 is returned for numbers.

✓
2 is returned for text.

✓
4 is returned for logical values.