N(R)

Top  Previous  Next

 

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.

 

Sponsored

Try Predictive Systems Lab

Interactive Demo →

Need Help?
Contact support