Super Long Formula
Posted on 2013-02-06
I have been working on a worksheet, which has seen many, many revisions. When I first started on this project, I had many "helper" cells. But as I learned more and more about Excel, I knew I could get rid of the helper cells - and have my answer be returned in just one cell.
Being that my worksheet is doing 100% of it's calculations in only one cell, my concern is the length of the formula.
Now I know it's all being forced into one cell, so of course my formula is going to be a monster - but are there any glaring issues with having a formula which is > 1000 characters long?
I would love to hear your opinion....
Thank you in advance!