Syntax: N(R)
R = a range
N returns the numeric value of the upper left cell in the range R, or zero if the cell is blank or contains a label. This function is included only for compatibility with older spreadsheets.
Examples:
A1..B3 =
| A | B | |
| 1 | 1 | ``electrons'' |
|---|---|---|
| 2 | 2 | ``protons'' |
| 3 | 3 | ``neutrons'' |
N(A1..B3) = 1
N(B1..B3) = 0
N(A1..Z25) = $1,000,000.00, where A1 = $1,000,000.00
Excel function: N/A