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.
Select File > Options.
Navigate to the Advanced options.
Tick the box next to Use system separators.
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