Not sure but give this a shot

=IF(D5="Cash","Cash",IF(AND(OR(D5="Discover",D5="M ASTER",D5="Master
card",D5="VISA"),NOT((K5="SCA/FACS NONCARILION")),NOT((K5="SCA/NORTH
CAROLINA"))),"VMD",IF(AND(D5="",OR(K5="SCA/FACS NONCARILION",K5="SCA/NORTH
CAROLINA")),"bkdf-SCA",IF(AND(D5="",C5<0,OR(K5="SCA/FACS
NONCARILION",K5="SCA/NORTH CAROLINA")),"bkdf-SCA-Crs",0))))

"Jim May" wrote:

Mike,
If you would again assist me.. This formula is a "Work-in-progress",
menaing I'm dealing with a rather complicated table structure (currently less
than 7 If's), but, right now with 5 if's -- the formula IS NOT picking up any
records showing "vsmc-sca-NonC" (the 5th If) but instead these same records
are being assigned "VMD" (the 2nd If). Can you spot my problem?

=IF(D385="Cash","Cash", <<1st If

IF(AND(OR($D385="Discover",D385="MASTER",D385="Mas ter
card",D385="VISA"),OR(NOT((K385="SCA/FACS NONCARILION")),NOT((K385="SCA/NORTH
CAROLINA")))),"VMD", <<2nd If

IF(AND(D385="null",C3850,OR(K385="SCA/FACS NONCARILION",K385="SCA/NORTH
CAROLINA")),"bkdf-SCA", << 3rd If

IF(AND(D385="null",C385<0,OR(K385="SCA/FACS NONCARILION",K385="SCA/NORTH
CAROLINA")),"bkdf-SCA-Crs", <<4th IF

IF(AND(OR(D385="MASTER",D385="VISA"),K385="SCA/FACS
NONCARILION"),"vsmc-sca-NonC", <<5th If

"bkdf"))))) << Current Default

Much Appreciated..

Jim May



"Mike" wrote:

Your Welcome

"Jim May" wrote:

Thanks Mike -- You Nailed it !!!
Jim May

"Mike" wrote:

),0))))
Remove the ) before the 0
,0))))
"Jim May" wrote:

=IF(D5="Cash","Cash",IF(AND(OR($D5="Discover",D5=" MASTER",D5="Master
card",D5="VISA"),OR(NOT((K5="SCA/FACS NONCARILION")),NOT((K5="SCA/NORTH
CAROLINA")))),"VMD",IF(AND(D5="null",OR(K5="SCA/FACS
NONCARILION",K5="SCA/NORTH
CAROLINA")),"bkdf-SCA",IF(AND(D5="null",C5<0,OR(K5="SCA/FACS
NONCARILION",K5="SCA/NORTH CAROLINA")),"bkdf-SCA-Crs"),0))))

I can't get the above formula In the last 0 is highlighted as being
the problem. tha'ts the 0 the 0)))) (5th chacacter from the end)
Can someone spot my problem?

Thanks in Advance,

Jim May