N(R) |
![]() ![]() ![]() |
Description
This function returns the numeric value of the upper left cell in the range R, or zero if the cell is blank or contains a label.
Parameters
R
A range.
Examples
Given:
0 |
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.
Try Predictive Systems Lab
Need Help?
Contact support