✔ [Resolved] Excel Error 'There's a problem with this formula' | ⚠ Excel Errors

=============================================================
=============================================================
The other day after upgrading to office 365 I got this weird-looking display window whenever I entered any function in my worksheet;

There's a problem with this formula.

Not trying to type a formal?

When the first character is an equal(=) or minus (-) sign, Excel thinks it's a formula.

you type: =1=1, cell shows : 2

To get around this, type an apostrophe (') first:

you type: '=1=1, cell shows: =1+1

Therefore, in this video, I will discuss how to resolve this error in a few solutions provided.

Let me know if you got to resolve it in the comment section.
=============================================================

[usinebeglaryan]

Thank you so much. After days of looking for a solution everywhere, only your video could help me. 🙏

[Namashkaram]

Thank you so much. After googling for more than a hour, found this very well explained video and got my error fixed. There was Regional setting in system.

[fatinizzati]

THANK YOU for this video! it really helps. I've changed the list separator and language and then problem solved!

[oleksandrmaksymikhin]

very simple and useful explanation. Thanks

[tutamcharity]

Thank you for your helpful video, thanks to you I was able to fix the client's error. Thanks for your support.

[Love_yourself]

Still facing the difficulties in logical operator, can you help me out?

[AhmedElHawy]

first solution worked like a charm! THANKS!

[arseniovasco]

It worked for me, thank you very much.

[pavankumar-tmyl]

Same as you say in video I am trying to avoid broken formula
But it does not work it

[aparnajayesh]

Thank you so much for this video. It worked 🤗.Thanks again 😊👍🏻

[albertoaguilar]

Dude, Thank you !!! I checked everywhere and I wasn't able to fix the issue because my formulas didn't work, some of them did but if statements wouldn't work neither date formulas. It was the "comma" regional parameter. Somehow it was set to "dot" by IT guys. Thanks again!

[rakandapangeran]

THANK YOU! Didnt know that list separator would matter that much 😂

[staryznowugra]

Worked first solution with list separator, thank you!

[tuanlinhphan]

Thank you so much . I spened a lot of time for this mistake, thank you

[ingemadden]

I am still having issues with any formula I try to type in this sheet/ doc. Can i send to you to check? Ive run out of ideas and energy to try get this right :(

[lisamisa]

Excellent! I went into region, then clicked on additional settings; changed the list separator to a comma and it worked! It was previously a “|” - your solution WORKED!!!! Many thanks!

[doozraboy]

Really helpful to me and my gratitude ✌

[hcch]

THANK YOU SO MUCH
the problem has been solved

[FunnyBangla]

I am from Bangladesh. After watching this video, I got a solution to my long time problem, so I subscribed. Thank you so much.❤️

[mohmmedshafi]

very helpfull, once we make these changes we need restart excel right?