Couple of things, you need to Extract your data before saving as a packaged (twbx) workbook (as is we can't open your workbook without signing onto your server).
Also you don't need any of those AND statements in your Revenue Bins formula. If it's greater than 10k it will be assigned the bin and then exit on line 1. If it's greater than 5K it will be assigned the bin and then exit. Adding the AND doesn't do anything because nothing greater than 10K is ever going to get to the 5K line.
Repost the workbook and we'll take a look.
Thanks for the clarity. See attached workbook with the extracted data.
Notice, as I mentioned earlier above - whenever I extract the info, the formulas seem to be working fine. I was hoping to duplicate the results in this extract below, in the live connection above.
help me extract.twbx 913.7 KB
Sorry I didn't pick up on that part of your question. This sounds to me like a support case.
Aw man. Okay thank you Shawn very much!