Just for clarifiction, because it confused me when I first started XL, that
is a limit of 7 *NESTED* functions, not a limit of 7 functions per formula.
Jim's original formula has a total of 18 IF's, AND's, NOT's & OR's.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Niek Otten" wrote in message
...
Hi Jim,

The limit is 7 nested functions, IF's or other functions, so that includes
NOT's and AND's

Look he

http://www.j-walk.com/ss/excel/usertips/tip080.htm


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jim May" wrote in message
...
| The following 6 deep Nested If is working fine (630 char long)
|
| =IF(AND(D1048="Cash",NOT((K1048="SCA/FACS
|
NONCARILION"))),"Cash",IF(AND(OR($D1048="Discover" ,D1048="MASTER",D1048="Master
| card",D1048="VISA"),NOT((K1048="SCA/FACS
NONCARILION"))*NOT((K1048="SCA/NORTH
| CAROLINA"))),"VMD",IF(AND(D1048="null",C10480,OR( K1048="SCA/FACS
| NONCARILION",K1048="SCA/NORTH
| CAROLINA")),"bkdf-SCA",IF(AND(D1048="null",C1048<0,OR(K1048="SCA/FACS
| NONCARILION",K1048="SCA/NORTH
|
CAROLINA")),"bkdf-SCA-Crs",IF(AND(OR(D1048="MASTER",D1048="VISA"),K1048= "SCA/FACS
|
NONCARILION"),"vsmc-sca-NonC",IF(AND(D1048="null",C1048<0,NOT((K1048="SCA/FACS
NONCARILION"))*NOT((K1048="SCA/NORTH
CAROLINA"))),"bkdf-Crs","bkdf"))))))
|
| But when I try and insert a 7th if (below) in between #1 and #3 If's
(also
| adding an additional ")" at the end
|
| IF(AND(D1048="Cash",K1048="SCA/FACS NONCARILION"),"SCA_CASH"
|
| it will not accept the formula, Highlighting the NOT only!! located from
the
| end as below:
| NOT((K1048="SCA/FACS NONCARILION"))*NOT((K1048="SCA/NORTH
| CAROLINA"))),"bkdf-Crs","bkdf")))))))
|
| Any ideas as to why this is occuring?
|
| Thanks in Advance for any help you can offer...
|
| Jim May