Menu
EXCEL VALUE FUNCTION
Excel VALUE Function Introduction
This function converts text to an integer value. The VALUE function converts text in a specified format (such as a number, date, or time) into an integer value.
Description of Excel VALUE Function
Syntax:
VALUE(text)
Parameter list:
- text – the text surrounded by quote marks, or a pointer to a cell holding the text to be converted.
- Normally, Excel transforms text to numeric values as needed, but in some situations, we may get data and we will be unable to perform any calculations on it; in this case, we must convert the text to numeric error value if the text is not in one of these formats.
Step By Step Guide of VALUE Function
Example :
As shown in the image below, there are the names of certain fruits, the amount, and we want to know the total number of fruits, which we can obtain by combining the value function with the left function.
If the data is not in an Excel-compatible format, it can be left as text. When this occurs, some functions, such as SUM or AVERAGE, disregard the data in certain cells, resulting in calculation mistakes. The #VALUE error is returned by a VALUE formula.
Text data aligns to the left in a cell, so you can track the data type by alignment as well. On the right cell, numbers and dates are aligned.
The function translates text in a recognised format (a number in the text, a date or time format, money, or a percentage) to a numeric value.
Normally, Excel translates text to numeric values as needed, therefore the VALUE function is rarely used.
Key Points
- Text can be in any of the constant number, date, or time forms that Microsoft Excel recognises.
- VALUE returns the #VALUE! error value if the content is not in one of these types.
- In most cases, you don’t need to utilise the VALUE function in a calculation since Excel automatically transforms text to numbers as needed.
- This function exists to provide interoperability with other spreadsheet systems.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
