Functions in programming
On Wed, 8 Oct 2008 06:33:01 -0700, ashoulds
wrote:
Does anyone know how many functions excel can handle in a single cell? I
have a pretty long formula that searches three tables for values and need to
add three more variables that will search three separate tables.
Check HELP for your Excel under Specifications.
There are nesting limits (different for different versions), and limits on the
length (number of characters) of a formula. I don't believe there are limits
as to the number of functions.
--ron
|