Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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",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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF Statement (Nested IF's??) | Excel Worksheet Functions | |||
Nested IF's with Rank Problem | Excel Worksheet Functions | |||
Nested If's | Excel Worksheet Functions | |||
How many IF's can you have in a nested IF function? | Excel Worksheet Functions | |||
How many nested IF's??? | Excel Discussion (Misc queries) |