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?

  • 1
    Hey, looks like this is a bug, since rank is working as described for me. Any chance you can reproduce it in a new sheet, and share it with us?
    – Jake Lee
    Commented Nov 26, 2016 at 14:10
  • There are similar reports on the Google Docs Editors official help forum in Spanish. I didn't take a look to the English forum yet. Please checkout it ->productforums.google.com/forum/#!forum/docs Commented Nov 26, 2016 at 16:44
  • When this happens, is the save status "all changes saved"?
    – Argyll
    Commented Mar 5, 2018 at 4:06

1 Answer 1


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.

  • I had the same issue now (2021). Using Chrome on Windows. I pressed F5 to reload to the page and the calculation results appeared. Thank you! Someone ought to mark your answer as the answer. Commented Mar 13, 2021 at 7:27
  • Had the same issue (2021), using MacOS and Firefox. Solved by refreshing. Commented Jun 4, 2021 at 9:53

Not the answer you're looking for? Browse other questions tagged or ask your own question.