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: