Home : VAL
Q11329 - INFO: VAL

VAL returns the numeric value of a text string.  Text strings that contain a numeric value or a number with an MDL symbol (ie “<2”) will be converted to a number. 

SYNTAX:

VAL(Value, optional Default_Value)

Value: Text value or Cell Reference

Default_Value: Optional.  Displays optional default value when symbol has not been set up. Looks for first numerical value using a symbol (<,>,ND...ect) and displays the numerical value.

EXAMPLES:

Formula Returns Comment
Val("4.7")  4.7
Val("<2") 

Symbols are removed and the numeric part is converted to a number. 
Val(C1) 4 Cell C1 contains the string “<4”
Val(VINFO(1,”Entry Min”))  15 VINFO is a text function that returns “15”, Val converts that to 15.0
Val("X",0) 0 Looks for first numerical value of symbol (<,>,ND). X is not a symbol that has been set up, therefore the default value (0) will be displayed.
Val("X")    - Returns nothing since there is no default value and X is not a symbol or a number. 
Val("ND")  0
Val(C2) 0 C2 is a blank cell.
VAL("100 mL") 100 Converts the numeric part until a non-numeric value is found.
VAL(" 123 Main, Hwy 74") 123 Spaces removed and value up to first non-numeric is converted.
VAL(IF(STR(D4)="PASS",1,0)) 1 Returns 1 if D4 = "PASS" and the cell type will be numeric.  Notice VAL overides the STR (which tries to make the cell type text) because VAL is the outer most function.  
STR(IF(VAL(B4)<10,"GOOD","BAD") GOOD Returns "GOOD" if the Value of B4 < 10.  Notice STR as the outer most function sets the cell type to text allowing GOOD (or BAD) to be displayed in the cell. 

 

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 6/5/2008 2:02 PM.
Last Modified on 3/8/2018 5:08 PM.
Last Modified by Scott Dorner.
Article has been viewed 2891 times.
Rated 4 out of 10 based on 2 votes.
Print Article
Email Article