next up previous contents index
Next: NA Up: A. Function Reference Previous: MSQ   Contents   Index


N

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


next up previous contents index
Next: NA Up: A. Function Reference Previous: MSQ   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003