Home : STR
Q10685 - INFO: STR

STR returns the string representation of the value. 

SYNTAX:

STR(cell reference/function)

NOTES:

WIMS will make the cell type Text (most WIMS formulas return numeric values, therefore cells are set to Num when formulas are entered, the STR function overrides this) if STR is the first part of the function.  See Examples.

EXAMPLES:

=STR(B2) Returns "Rocky Creek" - Cell B2 has the text "Rocky Creek"

=STR(IF(VAL(C1)>60,"PASS","FAIL"))  Returns PASS if C1 is greater than 60.  If STR is not used cell would be made a Num cell and would always return a blank result.

=VAL(IF(STR(D4)="PASS",1,0)) - returns 1 if D4 = "PASS" and the cell type will be numeric.  Notice the VAL function overrides the STR (which tries to make the cell type text) because VAL is the outer most function.   

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 1/31/2008 9:35 AM.
Last Modified on 1/25/2016 1:13 PM.
Last Modified by Scott Dorner.
Article has been viewed 5548 times.
Rated 4 out of 10 based on 1 vote.
Print Article
Email Article