Formula Errors

Fix an Excel 365 FV Formula Error Caused by List Separators

John WilsonJohn Wilson Nov 20, 2026 869 views

Question details

The user needs to resolve an FV formula error in Excel for Microsoft 365.

Fix an Excel 365 FV Formula Error Caused by List Separators
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.
Before you start

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.

Solution 1Recommended

Match the FV formula to your regional separators

Use this approach if Excel rejects the formula or cannot interpret its arguments.

1
Check Windows regional settings

On Windows, search for intl.cpl and open it. On the Formats tab, select Additional settings, then check the List separator and Decimal symbol.

2
Adjust the formula

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.

3
Restart if necessary

If you changed a Windows regional setting, close and reopen Excel. If the error persists, restart the computer and enter the formula again.

Match the FV formula to your regional separators
Regional settings affect other apps: Changing the Windows list separator can affect other programs. Adjusting the formula to match the existing setting may be preferable.
Free Microsoft Office alternative

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.

Use FV formulas to calculate future values in spreadsheetsOpen and edit Microsoft Excel XLSX filesNavigate a familiar spreadsheet interfaceMove existing workbooks to a lightweight Office suite
microsoft office alternative - wps office

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.