Formula Engine Reference Guide
 

 

Back to Class Index

 

S(R)

Description
Returns the string value of the top left cell in range R, or a null string ("") if the cell is blank or contains a numeric value.
 
Parameters
R

A range
 
Examples
A1..B3 =
A B
1 electrons
2 protons
3 neutrons
S(A1..B3) = " "
 
S(B1..B3) = "electrons"
 
S(A1..Z25) = " "
where A2 = $1,000,000.00