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.
How to fix the Excel’s There’s a problem with this formula error?
1. Check your system regional settings
2. Change correct spelling settings
3. Enable system separators
1. Open Microsoft Excel. 2. 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.
Name *
Email *
Commenting as . Not you?
Save information for future comments
Comment
Δ