Compound If, And Or - can
Mike, Thanks - but no It didn't work. I started a new thread 8 or 10 up from
this one and Niek has begun to shed some light on my INCORRECT 2nd If
Statement.
Join us there?
Jim
"Mike" wrote:
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
|