How to use the Excel VALUE function

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:

Excel VALUE - How to use the Excel VALUE function

Syntax:  =VALUE(A15)

Result:

Excel VALUE function - How to use the Excel VALUE function

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

Add a Comment

Your email address will not be published. Required fields are marked *