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")
There is no symbol for "actual" in Excel, but there is a function to display absolute value (ABS).
The FV function calculates the future value of an investment.
The MODE function.
The MATCH function can do that.
The MATCH function.
There is no symbol for "actual" in Excel, but there is a function to display absolute value (ABS).
The FV function.
In Excel you can use the ISNUMBER() function.
FV = Future Value
The IF function. See the related question below.
Use the function ABS. =ABS(-11) returns the value 11.
A function.