next up previous contents index
Next: NAND Up: A Function Reference Previous: MSQ

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


next up previous contents index
Next: NAND Up: A Function Reference Previous: MSQ

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999