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?