Google-sheets – Formula result doesn’t show, leaves blank cell

google sheets

I have a spreadsheet and between B2:B101, I have a number on each one. I am trying to get a rank on E2:E101, regarding to their given number. I tried using =rank, and it successfully shows the result in a tooltip, but when I press enter, it doesn't write the value.

enter image description here

The cell is blank.

View > All Formulas is unchecked, also tried with checked. No luck. What am I doing wrong?

Best Answer

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.