Some Windows 10 users encountered an unexpected issue with Microsoft Excel.

First of all, ensure your regional settings are correct

  • Windows 10 users have been encountering the following Excel error: there’s a problem with this formula.This error does not allow users to use the formula function.We prepared you a guide with 3 easy methods to fix this error.

When trying to use a formula making different calculations, the error message There’s a problem with this formula disallows the formula function.

This is how one user describes this bug:

If you’re looking for a way around this issue, follow the solutions below.

I have a simple formula that I have been using for years. Actually, worked until a couple of days ago.  =round((a2/0.25),0)*0.25. This is used to round our retail price to the nearest quarter. When I tried to execute this formula now, I get an error window: There’s a problem with this formula.

How to fix the Excel’s There’s a problem with this formula error?

1. Check your system regional settings

  • Open the Control Panel
  • Under Clock and Region, click Change date, time, and number formats
  • In the Formats section, click Additional settings…
  • Under the Numbers tab, make sure that the List separator is set to comma(,), if not, set it so
  • If the issue persists, change the List separator with a semicolon (;) and use it in your formula to replace the comma.

2. Change correct spelling settings

  • Open Microsoft Excel
  • Select File > Options
  • Go to the Proofing section > make sure to have the box next to Ignore words that contain numbers ticked

3. Enable system separators

1. Open Microsoft Excel.

  1. Select File > Options.

  2. Navigate to the Advanced options.

  3. Tick the box next to Use system separators.

  4.  Click OK to apply and save the changes.

If you encountered the Excel there is a problem with this formula error, you can get rid of it by enabling system separators in the app’s built-in settings.

Let us know if our guide helped you fix the Excel issue in the comment section below. Likewise, if you have any questions, don’t refrain from writing them down.

  • Excel Online won’t calculate/ won’t open [Best Solutions]

  • Microsoft Excel is waiting for another application to complete ole action

  • Excel we’re having trouble connecting to the server [Fix]

  • Excelwindows 10 fix

Email *

Commenting as . Not you?

Comment