Excel has gone crazy on me...

[albertc30]

Hello everyone.

I have just started to see excel behaving in a very weird way.

It says a simple formula like "=121.5+10+20" is incorrect and says there's an error on the cell that contains the formula, it says inconcistent formula.

Also, something like "=COUNTIF(D21:Q21,">0")" returns a 9 on the insert function but once you press enter on the formula on the cell, it returns zero.

What on earth is going on with excel?

Tried someting like Stellar Repair for Excel but still the issue persists.

Anyone had this issue? How to fix this? It's rather frustrating.

Many thanks everyone and be safe out there.

Thanks

 

[joeu2004]

joeu204 ... calm down brother. That was parody.

Oh, I wasn't upset by your comments at all. I was truly curious where/if you found a bona fide "Excel User Manual". Guess not.

I __am__ upset that products no longer come with user manuals. And when they do provide a so-called "user manual" online, it is little more than a few useless pages. Not the detailed reference manuals that we used to see before the "internet era". Sigh.

And I __am__ upset by the revised Excel help pages: the loss of details, as well as the blatantly incorrect "details".

But you're right: it is what it is. ``Grant me the serenity to accept the things I cannot change / Courage to change the things I can / And wisdom to know the difference.``