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

Опубликовано: 05 Март 2020
на канале: Excel Tutorial
159,541
1.1k

learn more about excel:- https://www.exceltutorial.net
=============================================================
=============================================================
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

And then I saw there are many people trying to resolve it on the excel forum:- https://answers.microsoft.com/en-us/m...

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.
=============================================================


Смотрите видео ✔ [Resolved] Excel Error "There's a problem with this formula" | ⚠ Excel Errors онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Excel Tutorial 05 Март 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 159,541 раз и оно понравилось 1.1 тысяч людям.