Forum Discussion
multiple rules in format code
Let's say I'm creating a scatter plot chart. So, I've entered in x and y values in the cells. I go to Insert chart, etc., and get the chart displaying just as I want it. Then, I notice there's no 0 d...
One option is to use 0,"K"
Apart from that, I have no problem creating three sections:
Or am I missing the point?
- Yeah, if I enter that (three rules separated by two semicolons), it will only add a code with the first two rules, so thanks for the reply but, as always, "works for me" isn't a huge help 🙂
Custom number format doesn't work with more than two conditions, that's by design I guess.
I understand that that isn't helpful, my apologies. What about my other suggestion?
By the way, what do you see when you open the attached version?
- Actually, I take back what I said. Your post was in fact helpful. I wasn't able to put in more than two conditions (as the post below points out), but it turns out I didn't need more than two conditions. Your suggestion helped me figure out what I needed. Here's what I ended up with (I was trying to get just "0" for the zero and a K for the other values): [>999999]#.0,,"M";[>999]#,"K";0
