In Google Sheets, I want to format 1230000 as 1.23 M and 1230 as 1.23 K. However, it seems I can only format either in terms of M, or K, not both.

It's possible to set formatting conditions in Excel, like in this article:


The code above will format values >1000000 in terms of "m" and format values >1000 in terms of "k".

I tried that in Sheets, but got "invalid format" error. So how do I add multiple formats for multiple ranges?

Browse other questions tagged or ask your own question.