Value function in Excel gives the value of a text which represents a number for example if we have a text as $10 this is actually a number format in a text, using value function on this data will give us 10 as result so we can see how this function gives us the numerical value represented by a text in excel.
Syntax: =VALUE(text)
The VALUE function syntax has the following arguments:
- Text (Required) The text enclosed in quotation marks or a reference to a cell containing the text you want to convert.
Example: Let’s look at some Excel VALUE function examples and explore how to use the VALUE function as a worksheet function in Microsoft Excel:
Syntax: =VALUE(A15)
Result:
Based on the Excel spreadsheet above, the following VALUE examples would return:
Syntax: =VALUE(A16)
Result: 0.0000001
Syntax: =VALUE(A17)
Result: 0.2
Syntax: =VALUE(A18)
Result: 10
Syntax: =VALUE(A19)
Result: 0.375
Syntax: =VALUE(A20)
Result: 43934
Syntax: =VALUE(A21)
Result: #VALUE!
Syntax: =VALUE(A22)
Result: #VALUE!
Syntax: =VALUE(A23)
Result: 600000
