Formula too long problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a rather large spreadsheet where in a single column I am attempting to
enter a formula when I get the message "formula too long". Are there any
work arounds for this?
 
hi,

You can try eliminate the $ of the formula if it's possible, or use another
cell or cells to get the partial results and consolidate all when you want,
try to see also if you are using mor than 7 if's.

hope this helps
Regards from Brasil
Marcelo

"rfritz" escreveu:
 
If you provide a bit more info, I'm sure we can help you solve your problem!
What is ti you want to achieve? What formula do you want to use?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Forumula too long 3
Excel Wildcard in Excel array formula 0
Replacing part of a (too) long formula 5
Formula to long error 2
Conditional formatting in Excel 2010 2
Formula Too Long Errors 1
Index/match across multiple columns? 19
Simplification of Formula 3

Back
Top