Is there any limit on command length ?

**velugu** · 05-21-2007, 01:34 AM

When I write a command, it is showing error.
I wrote the command as below, for ex.
IF(OR(ISBLANK(A86),NOT(ISERROR(FIND("bmw",A86)))),"","set address "&MID(A86,13,5)&CHAR(10)&CHAR(13)&" momentum &..............................)

I copied the text from NOTEPAD and pasted in EXCEL Cell.
After that I press "ENTER", it showd some error and when I say "OK", it
selecting MID function. The function format is perfect.

I have few queries here.
1. Is there any limit on no.of chars on a COMMAND ?
2. Is there any restriction on no.of "IF" to be used ?
3. Or limitation on Nested IFs ?
4. Is there any limitation on using same function (Ex. MID) using N no.of times ?

Please do help me...
THanks in advance to be out of

.

**sweep** · 05-21-2007, 02:54 AM

Hi,

1. Is there any limit on no.of chars on a COMMAND ?
2. Is there any restriction on no.of "IF" to be used ?
3. Or limitation on Nested IFs ?
4. Is there any limitation on using same function (Ex. MID) using N no.of times ?

7 Nested IFs
Arguments in a function 30
Nested levels of functions 7
Number of available worksheet functions 329
Earliest date allowed for calculation January 1, 1900 (January 1, 1904, if 1904 date system is used)
Latest date allowed for calculation December 31, 9999
Largest amount of time that can be entered 9999:59:59

**mudraker** · 05-21-2007, 03:59 AM

velugu

Welcome to excelforum

Please read forum rules - see links below

The programming forum is for VBA/Macro type questions

What you posted appears to be a formula type question and would be expected to be posted in Excel Worksheet Functions forum.

Thread: Is there any limit on command length ?

Thread Tools

Display

Is there any limit on command length ?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions