Forum Discussion
Numer Format Condition Limits
I am attempting to create a new number format which would split my numbers automatically like the following:
< 100,000: 0-10000
< 10,000,000: 100 K - 9999 K
< 10,000,000,000: 10 M - 9999 M
> 10,000,000,000: 10 B - 9999 B
I ran into an issue when using the following condition format:
`[<1e5]0;[<10e6]0, "K";[<10e9]0,, "M";0,,, "B"`
It works fine if I only have the first two conditions. Is there a limit on those? Because I get the following error, which isn't very helpful.
Thank you all for your time in helping me with this.
Microsoft official documentation apparently does not make it explicit, but you can have only two "condition value" sections (and only three number sections in total) in a custom format. This Tech Community article by Excel MVP Liam Bastick mentions "A number format may contain up to two conditions". (Search for "uninitiated", as he put that text into an image.)
Further down in the article, Liam describes how you can use conditional formatting to work around that limit.
