Custom Format with multiple conditonals

[Lance Roberts]

I've found a problem doing custom formats for a cell in that the semicolon is
used as a separator for the positive/negative/zero/text fields, and it's used
as a separator for conditionals like [>100]#;[<100]"N/A", so I'm unable to
figure out how to do something like this (which doesn't work):

[>=1000000]$0.0,,"M";[>=1000]$0,"K";[<=-1000000]$0.0,,"M";[<=-1000]$0,"K"

How do you implement mulitple conditions for both positive and negative
numbers?

 

[Bernard Liengme]

I seem to recall your get only 3 number formats plus one text, and only two
of the number formats can have conditions.
best wishes