| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
maximum number of characters within a forumla?
I have a formula that I keep getting an error on - is there a maximum number
of characters allowed in a formula. It keeps highlighting "IF" and won't allow me to complete the formula. -- Barb |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
maximum number of characters within a forumla?
I've found that the complexity of the formula (number of arguments and
nesting) that is more limiting than the number of characters. Regards. Bill Ridgeway Computer Solutions "B G" wrote in message ... I have a formula that I keep getting an error on - is there a maximum number of characters allowed in a formula. It keeps highlighting "IF" and won't allow me to complete the formula. -- Barb |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
maximum number of characters within a forumla?
Could be either of two limits.
1. 1024 character limit for formulas. 2. 7 nested "IF",s in a formula. See Help on "limits and specifications" for other parameters. Gord Dibben MS Excel MVP On Wed, 26 Jul 2006 07:32:02 -0700, B G wrote: I have a formula that I keep getting an error on - is there a maximum number of characters allowed in a formula. It keeps highlighting "IF" and won't allow me to complete the formula. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting rows based on number of characters | Excel Discussion (Misc queries) | |||
| Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
| maximum number from a text range | Excel Worksheet Functions | |||
| Count Number of Characters in a cell? | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
