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

Madalina Dinita
by Madalina Dinita
Madalina has been a Windows fan ever since she got her hands on her first Windows XP computer. She is interested in all things technology, especially emerging technologies -- AI and DNA computing in... Read more
Affiliate Disclosure
fix Excel formula problems
To fix various PC problems, we recommend DriverFix:
This software will keep your drivers up and running, thus keeping you safe from common computer errors and hardware failure. Check all your drivers now in 3 easy steps:

  1. Download DriverFix (verified download file).
  2. Click Start Scan to find all problematic drivers.
  3. Click Update Drivers to get new versions and avoid system malfunctionings.
  • DriverFix has been downloaded by 0 readers this month.

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

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:

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.

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

Why are my formulas in Excel not working?

1. Use system separators

  1. Open Microsoft Excel
  2. Select File > Optionsexcel formula issues
  3. Go to the Advanced options > tick the box next to Use system separators > click OK.

2. Check your system regional settings

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

3. Change correct spelling settings

  1. Open Microsoft Excel
  2. Select File > Optionsexcel formula issues
  3. Go to the Proofing section > make sure to have the box next to Ignore words that contain numbers ticked

Let us know if our guide helped you fix the Excel issue in the comment section below.

READ ALSO:

This article covers:Topics: