Solved

# Super Long Formula

Posted on 2013-02-06

Hello Experts,

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!

~ Geekamo