Forum Discussion
Need for more than 64 levels of nested - Simplify formula
Nikoss I and re-attaching the sheet. I deleted the other formulas on that sheet in case there was some confusion. It works just fine for me. Maybe you could explain a little more what you mean by it giving the wrong results. Does it sometimes give correct results? Does it ever change? Can you give an example of a wrong result and what it gave and what you wanted it to give?
Bennadeau although it works on the sample sheet it doesnt work on my original one for some reason so something is wrong with the original one probably. Again, I would like to thank you for your help on this, it is very much appreciated!
You may want to check to make sure your cell formatting match.
Number formatting when only numbers are present
Currency when it's a $ amount
Text for everything else.
In both sheets of course.
Also, ensure there is no trailing space in your cells (white space at the end or "2016" for example). This will mess up things.