answersLogoWhite

0

What is the excel value function?

Updated: 8/19/2019
User Avatar

Wiki User

12y ago

Best Answer

It takes numbers that are stored as text and converts them in to actual values. So, for example, the following formula will result in the number 65:

=VALUE("65")

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the excel value function?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What symbol is in excel?

There is no symbol for "actual" in Excel, but there is a function to display absolute value (ABS).


What Excel function calculates the future value of an investment?

The FV function calculates the future value of an investment.


What function in Microsoft Excel determines most frequent value?

The MODE function.


What function searches for a specific value in a table and returns that value's relative position from the table not the value itself in Excel?

The MATCH function can do that.


What excel function searches for a specific value in a table and returns that value's relative position from the table not the value itself?

The MATCH function.


What is Actual symbol in Excel?

There is no symbol for "actual" in Excel, but there is a function to display absolute value (ABS).


What Excel function can be used to calculate the futue value of any investment?

The FV function.


Which function can be used to check whether the value is numeric or not?

In Excel you can use the ISNUMBER() function.


What is the value at the end of the time periods in an Excel function known as?

FV = Future Value


Which function returns one value when a condition is met and returns another value when it is not met in Excel?

The IF function. See the related question below.


What would be a formula for absolute value in excel?

Use the function ABS. =ABS(-11) returns the value 11.


What is a named operation that returns a value in the Excel program used to simplify formulas?

A function.