Microsoft Office Tutorials and References

In Depth Information

**N**

The
ISNUMBER
function can be combined with cell references to return a text result based on

whether a number meets the criteria of the number specified in the formula. Notice the

example in Figure 7.6.

This is the cell or range you want tested.

VALUE

A

ISNUMBER criteria

Figure 7.6

Combine the

ISNUMBER
function

with the
IF
function

to return results

based on whether

the criteria is met.

B

If True, the result

N
N
returns the value converted to a number.

=N(value)

The
N
function converts values listed in Table 7.5. This function is generally not needed by

Excel and is provided primarily for compatibility with other spreadsheet programs.

This is the value you want converted.

VALUE

The values in the following table show the values and the return results based on the
VALUE

reference.

Table 7.5

N
Conversion Values

The Value Refers to…

Returns the Result

A number

The number

A date from built-in date formats

The serial number of that date

True

1

Anything Else

0