New Contributor

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

4 Replies

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

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:


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

@Joe User , here is automatic conversion.


also works fine despite we use text representation of numbers.

However, both


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


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

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