View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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