learn more about excel:-
=============================================================
=============================================================
The other day after upgrading to office 365 i got this weird looking display window whenever i enter any function in my worksheet;
There’s a problem with this formula.
Not trying to type a forumal?
When the first charcter 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 apostrphe (‘) firts:
you type: ‘=1=1, cell shows: =1+1
And then i saw there are many people trying to resolve it on excel forum:-
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.
=============================================================
Tag: lỗi microsoft excel has stopped working, excel errors, excel error bars, excel error in value, excel error checking, excel error function, excel error formula, formula problem, theres a problem with formula, excel formula errors, excel erros 2020, errors in excel, excel error 2016, excel 2016 errors, excel 2019 errors, excel 2013 errors
Xem thêm: https://kênhreview.vn/category/cong-nghe
Nguồn: https://kênhreview.vn
I am facing this issue and unable to fix this can you please help me
It doesn't work
thank you bro this was so useful for me!
Great job!
You are Excellent Bro you solved my issue in less than 2 minutes *******
Change language to English (United States) worked for me thank you bro . From Egypt ❤️
Oh goodness, it worked! Thank you so much! 😌 What helped me was changing the "Use system separators" option. I honestly had this error so often, I was going crazy…
Thank u u saved my life <3 the problem was in cama that wasn't the right one god bless u
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 🙁
Not resolved
Cause I had coma as list separator, my IF function stopped working. Changed it back to ; and it worked, thanks
THANK YOU SO MUCH
the problem has been solved
If you copy and paste from Word, another issue is that Word considers different characters, you need to replace these characters to the ones in Excel (ie. ’ to ') please find below the characters and differences:
Software Character Code()
Excel ' 39
Word ’ 146
Excel " 34
Word ” 148
Oh my it is working?! Wooow … thank you so much!
Thank you !
Thank you it finally worked
THANK YOU! Didnt know that list separator would matter that much 😂
I'm really struggling with this kind of error give more options plz,all the solution u said tried but still (excell error is on)
didn't work the error still pops up when i use if and or formula.
It doesn't work
NOT WORK
Thank you so much. After days of looking for a solution everywhere, only your video could help me. 🙏
it worke, before i use (;) error. now i use (,) it work thank you
Thank you so much.. Itsworked
It worked for me, thank you very much.
Thank you, the error might come if your are using a formula in a language different from the program:s language on you PC.
For example if i take a formula from an englidh youtuber and typr it in my computer with swedish language activated.