Custom Format with multiple conditonals
 

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?

--
Lance Roberts
Control Systems Engineer
Golden Valley Electric Assoc.

Custom Format with multiple conditonals
 

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
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Lance Roberts" <LJRoberts(at)gvea.com wrote in message
...
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?

--
Lance Roberts
Control Systems Engineer
Golden Valley Electric Assoc.