M
Matt
How do I extend the amount of characters an Excel formula will allow me to
enter?
enter?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jason Morin
You don't, but you can used defined names to shorten your
formulas. To learn how to implement them, see:
http://www.cpearson.com/excel/named.htm
http://www.xldynamic.com/source/xld.Names.html
HTH
Jason
Atlanta, GA
formulas. To learn how to implement them, see:
http://www.cpearson.com/excel/named.htm
http://www.xldynamic.com/source/xld.Names.html
HTH
Jason
Atlanta, GA
B
Bernard Liengme
When you use 'specification's and look up formula length Help tells you that
the maximum length of a formula is 1024 characters. If there was some way of
making it more, Help would say it was some other number.
Generally if a formula is too long you need to simplify it using: 1) more
that one cell to achieve the result, or 2) restructuring the formula (e,g
using lookups in place of long IFs, etc.
We would need more info to be of any help
best wishes
the maximum length of a formula is 1024 characters. If there was some way of
making it more, Help would say it was some other number.
Generally if a formula is too long you need to simplify it using: 1) more
that one cell to achieve the result, or 2) restructuring the formula (e,g
using lookups in place of long IFs, etc.
We would need more info to be of any help
best wishes
B
Biff
Hi!
The limit is 1024 chars. That's a long formula!
There's no way to get more than that but what you should
do is try to reduce the length of the formula.
One common issue that leads to this is the use of long
paths and sheet names as references. If that's not an
issue then perhaps you can split your one long formula
into several smaller intermediate formulas.
Biff
The limit is 1024 chars. That's a long formula!
There's no way to get more than that but what you should
do is try to reduce the length of the formula.
One common issue that leads to this is the use of long
paths and sheet names as references. If that's not an
issue then perhaps you can split your one long formula
into several smaller intermediate formulas.
Biff