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:[>1000000]$#.0,,m;[>1000]$#,k;$#,##0The 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?Thanks!
Google Sheets: how to custom number format based on value?
google spreadsheets