VALUE Function in Excel

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 $5 this is actually a number format in a text, using value formula on this data will give us 5 as result so we can see how this function gives us the numerical value represented by a text in excel.

Syntax

The Value formula is as follows:

Value Formula

The Value function has only one argument, and this is the required one. The Value formula returns a numeric value.

Where,

  • text = the text value that is to be converted into a number.

Examples to use VALUE Function in Excel

VALUE function is a Worksheet (WS) function. As a WS function, it can be entered as a part of the formula in a cell of a worksheet. Refer to the examples given below to understand better.

You can download this VALUE Function Excel Template here – VALUE Function Excel Template

Example #1 – Convert TEXT into Number

VALUE function Excel Example 1

In this example, cell C2 has a VALUE formula associated with it. So, C2 is a result cell. The argument of the VALUE function is “$1000,” the text which is to be converted into the number. The result is 1000.

Example #2 – Convert TIME of the day into a number

VALUE function Excel Example 2

In this example, cell C4 has a VALUE formula associated with it. So, C4 is a result cell. The argument of the VALUE function is “14:00,” which is the time of the day. The result of converting it into a number is 0.58333

Example #3 – Mathematical Operations

VALUE function Excel Example 3

In this example, cell C6 has a VALUE formula associated with it. So, C6 is a result cell. The argument of the VALUE function is the difference between the two values. The values are “1000” and “500”. So, the difference is 500, and the same is returned by the function.

Example #4 – Convert DATE into Number

VALUE Example 4

 In this example, cell C8 has a VALUE formula associated with it. So, C8 is a result cell. The argument of the VALUE function is “01/12/2000,” which is the text in the date format. The result of converting it into the number is 36537.

Example #5 – Error in VALUE

VALUE Example 5

In this example, cell C10 has a VALUE formula associated with it. So, C10 is a result cell. The argument of the VALUE function is “abc,” which is the text in an inappropriate format, and hence the value cannot be processed. As a result, #VALUE! is returned, indicating the error in value.

Example #6 – Error in NAME

VALUE Example 6

In this example, cell D2 has a VALUE formula in excel associated with it. So, D2 is a result cell. The argument of the VALUE function is ppp, which is the text in an inappropriate format, i.e., without double quotes (“), and hence the value cannot be processed.

As a result, #NAME! is returned, indicating the error is with the name provided.  The same would be valid even if a valid text value is entered but not enclosed in the double-quotes. E.g., VALUE (123) shall return #NAME! as a result.

Example #7 – Text with NEGATIVE VALUE

VALUE Example 7

In this example, cell D4 has a VALUE formula associated with it. So, D4 is a result cell. The argument of the VALUE function is “-1,” which is the text containing a negative value.  As a result, the corresponding value -1 is returned by the VALUE function Excel.

Example #8 – Text with FRACTIONAL VALUE

VALUE Example 8

In this example, cell D6 has a VALUE formula in excel associated with it. So, D6 is a result cell. The argument of the VALUE function in Excel is “0.89,” which is the text containing a fractional value.  As a result, the corresponding value of 0.89 is returned by the VALUE function.

Things to Remember

Recommended Articles

This has been a guide to VALUE Function in Excel. Here we discuss the VALUE Formula and how to use it along with an excel example and a downloadable template. You may also look at these useful functions in excel –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>

Reader Interactions

Leave a Reply

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