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.
Search JabSto ::




Custom Search