World of Warcraft: Google Sheet custom number format for gold

gistfile1.txt

Format: [>9999999999]###\,###\,###"g "##"s "#0"c";[>9999999]###\,###"g "##"s "#0"c";#0"g "00"s "00"c";

How it looks
           0g 00s 00c
           0g 00s 12c
           0g 01s 23c
           0g 12s 34c // Does not support hiding silver/copper
           1g 23s 45c
          12g 34s 56c
         123g 45s 67c
       1,234g 56s 78c
      12,345g 67s 89c
     123,456g 78s 90c
   1,234,567g 89s 01c
  12,345,678g 90s 12c
 123,456,789g 01s 23c
1234,567,890g 12s 34c // Breaks on values greater than 1B gold

Alternative: [>9999]###"g "##"s "#0"c";[>99]##"s "#0"c";#0"c"

Display:
                 1c
                12c
             1s 23c
            12s 34c
         1g 23s 45c
        12g 34s 56c
       123g 45s 67c
      1234g 56s 78c // No commas
     12345g 67s 89c
    123456g 78s 90c
   1234567g 89s 01c
  12345678g 90s 12c
 123456789g 01s 23c
1234567890g 12s 34c

Unfortunately, Google Sheets does not allow you to have more than two conditionals so this is the best I could come up with.