I have a formula, about 560 characters length
Copied 14 times, cell length become 7842
I can not add another copy (560 length), 15th one
What to do ?
I have Office 365
I have a formula, about 560 characters length
Copied 14 times, cell length become 7842
I can not add another copy (560 length), 15th one
What to do ?
I have Office 365
What to do?
Find a better formula
See specs of limits
https://support.office.com/en-us/art...7-269d656771c3
it is over 32.000 characters, so that is not it..
But formulas have limits too
most common example is nested IF do not know what the exact limit is now..
if you have a lot of nested if, see if the new IFS formula in office 365 can handle it better.
otherwise provide more details on the formula or google yourself for limits on specific formulas
There should definitely be ways around that formula (unless you've used a lot of embedded text).
Explain what you're trying to achieve and (dare I say it) paste a COUPLE of your formulas so we can try and identify a pattern.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
14 copy, 7842 works
15 copy, 8406 do not
in formula is one IFERROR and one IF
564 formula length
Last edited by ionelz; 01-21-2019 at 02:09 PM.
What's the formula? Please post three sections (copies) to give us an idea
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
How exactly is it not working? Does it throw a particular error code?
This is all baseless speculation without seeing samples, but I can also imagine that, on top of going over some limit on arguments into a function, it might be pulling through a bad reference (the #REF! error), or you might be running into a special case with this new row where it just happens that set of arguments is doing something unallowed like dividing by zero (the #DIV/0! error). Those are just off the top of my head.
With a function that dang long, you're going to run into serious readability risk -- it's very hard to figure out what it is doing, nevermind figuring out if it's doing what you think it's supposed to be doing.
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks