What is the maximum length of formula?



What is the maximum length of formula?..

Answer / Sarvesh Kumar Pandey

The maximum length of a formula in Excel depends on your version. For Excel 97-2003, the maximum formula length is 8191 characters, while for Excel 2007 and later versions, it is 32,767 characters.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MS Excel Microsoft Interview Questions

How do you change preferences in excel?

1 Answers  


Is excel and word included in windows 10?

1 Answers  


How do I merge cells in excel for mac?

1 Answers  


How do you use the average function in excel 2016?

1 Answers  


When I apply fill colour to a cell, I can not see it on the worksheet. However, the colour shows up in print preview, or when I print the worksheet. Whats wrong?

1 Answers  


How do I apply multiple conditional formatting rules in excel?

1 Answers  


What is vlookup function?

1 Answers  


How do I delete a worksheet in excel 2016?

1 Answers  


How do you insert a row on excel?

1 Answers  


What is ribbon?

1 Answers  


How do you link data in excel?

1 Answers  


What are the basic features of ms excel?

1 Answers  


Categories