Formulas not working in Google sheets that work in Excel - Help?

[KatyMac]

I have a lovely spreadsheet in excel with lots of fab formula (Vlooup and Iferrors etc) & when I import it into Google sheets the formula don't work

Am I being daft or are they not compatable?

Nope

God yu lot are so patient - I am such a numpty

Why can't I see the 'result'

Before you go nuts - try closing down, and then reloading. I've just found this on another site

Just had the same issue and it looks like it's just a bug that's easily fixed by reloading the page.

I had it on a document that I'd worked on in a previous browser session and all my existing formulas were fine but if I changed the inputs then the new results did not display. Also, any new formula failed to display results.

So it seems that for a particular browser session it fails to write formula results to the cell output.

(credit: webapps.stackexchange.com/questions/100658/formula-result-doesnt-show-leaves-blank-cell)

EggysMom you are a genius - my original formulas are now working!!

The whole shebang

I love you & you too Random and everyone on the thread and MN in general

I thought I was going mad!

OMG I could weep on your behalf it sounds as infuriating as excel on line...

& I mean the fix is so obvious

Turn it off then turn it on again!!

In return, thank YOU for introducing me to an area of MumsNet that I never knew existed - Geeky Stuff. I shall have to wander in here more often

How can it just decide not work 🤬

It's technology. It does stuff like that. If tech didn't misbehave occasionally, half of IT professionals and one-third of the internet would not be required. Even Peppa's father, Daddy Pig, fixes their computer by turning it off and on again. That was an episode pf Peppa Pig that made me giggle

I could honestly cry!

AT least it's sorted now!!

Thank you all so much I really appreciated your help

Just finished

Phew!