Excel: Maximum Number of Characters in a Formula Is Incorrect

Last reviewed: November 3, 1994
Article ID: Q75810

Summary:

Page 127 of the "Microsoft Excel User's Guide" version 3.0 for the Macintosh manual incorrectly states that "Microsoft Excel accepts formulas up to 4,096 characters long." A formula is limited by 1024 bytes of information, not characters. Depending on the complexity, your formula may be as many as 300 characters. Text strings are limited to 255 characters.

More Information:

For more information on the limitations of a formula's length, query on the following words:

   formula and complexity

KBCategory: kbother
KBSubcategory:
Additional reference words: 3.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 3, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.