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