• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel file with maximum number of commands

V

VDS

Member
Dear Respected members,

Is anybody else can provide the excel file which uses maximum number of commands. Only functions and not macros.

I do understand maximum of 64 commands can be used together. Right now I am using Excel 2010 version.

It is only for reference purpose. Take little bit of time and share your views.

VDS
 
That's a pretty odd request, as with over 250 different functions, the combinations you could do of making 64 nested levels is well into the billions. Also, with no real goal, I'm not sure why we would want to go that deep into a nested formula. I suppose a simple one would be to nest 64 SUM functions inside each other, like

=SUM(SUM(SUM(SUM(...SUM(A2:A10)...))))

But again, why would you want such a thing?
 
...64 commands can be used together
Click to expand...

Then what is your question?
You can simply build nested if statement to test, or use sum as Luke suggested.
=IF(A1=1,"A",IF(A1=2,"B",...))))))
 
You must log in or register to reply here.
Back
Top