Custom Format with multiple conditonals

  • Thread starter Thread starter Lance Roberts
  • Start date Start date
L

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?
 
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
 
Back
Top