Editing and Moviing from 6 If's to 7 Ifs (Nested)
The limit is seven nested functions - not just IFs - and I see that
you have a lot of ANDs and ORs and NOTs which will contribute to this
count.
I'm not sure why you have this:
NOT((K1048="SCA/FACS NONCARILION"))
Can't you use:
K1048<"SCA/FACS NONCARILION"
instead?
Hope this helps.
Pete
On Oct 3, 12:05 pm, Jim May wrote:
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="Ma*ster
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= "SC*A/FACS
NONCARILION"),"vsmc-sca-NonC",IF(AND(D1048="null",C1048<0,NOT((K1048="SCA/F*ACS 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
|