 Highlighted

# Correction

What is the meaning of #VALUE! . In Financial Function, FV.

4 Replies
Highlighted

# Re: Correction

@Oji-C-1615 , FV returns #VALUE! error if one of the arguments is not number.

Highlighted

# Re: Correction

FV("1%","60","-100","-1000","1") works just fine, despite the fact that the parameters are text.

@Oij-C, if you have a question about your use of an Excel function, it behooves you to show us how you are using the function (copy from the Formula Bar), as well as any cell values that you reference.

A #VALUE error might indicate that a parameter is or references text that Excel does not recognize as numeric.  The format of the cell does not matter.  Use a formula of the form =ISNUMBER(--A1) to determine if A1 is numeric or can be interpreted as numeric.

Some common causes:

1. The separators, typically period (".") and comma (","),  are not consistent with the configuration.

2. The "number" contains non-breaking spaces (CHAR(160)).  Use a formula of a formula of the following form to remove unwanted spaces and non-breaking spaces:

=--SUBSTITUTE(SUBSTITUTE(A1,CHAR(160),""),CHAR(32),"")

Copy the result, and paste-value into the original cell (A1, in this example).

Highlighted

# Re: Correction

@Joe User , here is automatic conversion.

`="5"+"3"*"4"`

also works fine despite we use text representation of numbers.

However, both

```=FV("1%","60","-100","-1000","One")
and
=FV("1%","60","-100","-1000","")```

return #VALUE!. The latest variant is quite common. If the last parameter is returned by formula like

`=IF(A1>B1,1,"")`

otherwise it returns empty string instead of zero, we have #VALUE! if use the value in such cell as parameter.

Highlighted

# Re: Correction

Thank you Sir, I got it later. I removed the text features, it returned the answer.