Fix an Excel 365 FV Formula Error Caused by List Separators
Question details
The user needs to resolve an FV formula error in Excel for Microsoft 365.

- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- A future value formula that worked in Excel 2007 is being entered in Excel for Microsoft 365.
- Observed behavior
- The formula =FV(0.0025,12,-200,4000,0) produces an unspecified error in Excel for Microsoft 365.
Check whether Excel rejects the formula when you enter it or displays an error in the cell after accepting it. Note the exact error message and whether your regional settings use a comma or a period as the decimal separator.
Match the FV formula to your regional separators
Use this approach if Excel rejects the formula or cannot interpret its arguments.
On Windows, search for intl.cpl and open it. On the Formats tab, select Additional settings, then check the List separator and Decimal symbol.
In the Excel formula bar, use the separator and decimal symbol shown in your settings. For example, use =FV(0.0025,12,-200,4000,0) with comma list separators and a period decimal symbol, or =FV(0,0025;12;-200;4000;0) with semicolon list separators and a comma decimal symbol.
If you changed a Windows regional setting, close and reopen Excel. If the error persists, restart the computer and enter the formula again.

Check Excel's decimal separator and formula values
Use this check if the formula is accepted but displays an error in the cell.
Work with FV formulas in WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar spreadsheet interface. Open compatible Excel workbooks and work with FV formulas as you move between applications.

Frequently Asked Questions
Does Excel for Microsoft 365 support the FV function?
Yes. Excel for Microsoft 365 supports FV. If a formula is rejected, check that its argument and decimal separators match your settings.
Where can I find the Windows list separator?
Search Windows for intl.cpl, open it, and select Additional settings on the Formats tab. The List separator appears with the other number-format settings.
Why does my FV formula use semicolons instead of commas?
Excel's argument separator can depend on regional settings. Where a comma is used as the decimal symbol, a semicolon is commonly used to separate formula arguments.
What should I do if changing the separator does not resolve the error?
Close and reopen Excel, then restart the computer if necessary. If the formula is accepted but returns an error, check its values and use Formulas > Evaluate Formula to investigate.




