Try=IF(ISNUMBER(SEARCH("PR1",B1)),"PR1",IF(ISNUMBER(SEARCH("PC1",B1)),"PC1",IF(

Try=IF(ISNUMBER(SEARCH("PR1",B1)),"PR1",IF(ISNUMBER(SEARCH("PC1",B1)),"PC1",IF(

Post by Christophe » Fri, 12 Nov 2010 03:39:09


Thank you so much for this, after two hours of internet searching, and three hours of excel frustration you have solved my problem. . .
 
 
 

1. New IFS interface (jfs.ifs, udf.ifs for example)

2. Editing and Moviing from 6 If's to 7 Ifs (Nested)

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",C1048>0,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

3. Why there is a need of IFS and non-IFS LSP sockets?

4. differecnce between ${IFS} and "${IFS}"

5. Small (JFS.IFS or HPFS.IFS AutoCheck) install bump, Solved!

6. Bug in CDFS.IFS/UDF.IFS

7. What does IFS="${IFS}[]()" mean?

8. nested ifs and end ifs and elses

9. IFs, ELSEs, END IFS -- proper construction

10. How do i keep it like this, A1:c1/b1, A2:c2/b1, A3: c3/b1?

11. =B2-B1 becomes B3-B2 for fill right and I want B3-B1 then B4-B1.

12. Trying to avoid nested IFs

13. conditional statement =IF(A1<B1,"<",IF(A1=B1,"=",">")) <--- don't

14. Trying To Put IFs into a Function

15. Error message when trying to open or delete a file thru IFS