LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 477
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF Statement (Nested IF's??) Jimmydageek Excel Worksheet Functions 8 February 19th 06 01:37 AM
Nested IF's with Rank Problem exutable Excel Worksheet Functions 2 November 9th 05 12:50 PM
Nested If's Cletus Stripling Excel Worksheet Functions 4 September 30th 05 01:14 PM
How many IF's can you have in a nested IF function? malik641 Excel Worksheet Functions 3 September 6th 05 02:07 PM
How many nested IF's??? malik641 Excel Discussion (Misc queries) 1 June 16th 05 09:35 PM


All times are GMT +1. The time now is 04:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"