1

Custom number formatting supports conditionals, but only two of them plus a default format. So, to display millions and billions of dollars, you can use Format > Number > More Formats > Custom number format with something like this: [>999999999.999]$#.00,,, "B";[>999999.999]$#.00,, "M";$#,##0_M Unfortunately, this will ...


Only top voted, non community-wiki answers of a minimum length are eligible