Thanks Niek -- I did as you said. And I see that on a record that should
come back "
"vsmc-sca-NonC" (the 5th If) - the 2nd If Is ALSO COMING Back True, so
naturally it is "grabbing" the FIRST If producing TRUE. So, my problem is in
my 2nd IF I'm sure. But I'm still stuck with IT !! (the 2nd If (isn't
corrent, obviously).. What's it's problem?

Thanks,

Jim May

"Niek Otten" wrote:

Why try to do this all in one formula? Break it up to intermediate results in different cells and integrate later, when testing is
finished.

BTW, any construction like

OR(NOT(A=1),NOT(A=2)) will always return TRUE; A must be unequal to at least one of them

--
Kind regards,

Niek Otten
Microsoft MVP - Excel



"Jim May" wrote in message ...
| This formula is a "Work-in-progress",
| meaning 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