S(R)

Top  Previous  Next

 

Description

This function returns the string value of the top left cell in the range R, or it returns a null string ("") if the cell is blank or contains a numeric value.

 

Parameters

 

R

A range.

 

Examples

 

Given:

 

0

A

B

1

1

electrons

2

2

protons

3

3

neutrons

 

S(A1:B3) = " "

 

S(B1:B3) = "electrons"

 

S(A1:Z25) = " "

Where A2 = 1,000,000.00.

 

Sponsored

Try Predictive Systems Lab

Interactive Demo →

Need Help?
Contact support