Microsoft Excel Functions & Formulas

Use the T function to check for valid numbers

Take a look at Figure 3-29. Notice that some numbers are listed,

but there are also references to text and other values. You can

check whether a number is a real value in an Excel worksheet by

using the T() function. This function checks whether a value is

text. If it is text, T returns the text; if it is not, T returns empty

text.

4

To check for valid numbers:

1. Enter some values in column A and change the format for

some of them to text (using the Cells option from the For-

mat menu).

2. Select cells B2:B10 and type the following formula:

=T(A2).

3. Press <Ctrl+Enter>.

88

Chapter 3

Figure 3-29