I didn't understand your comment "A must be unequal to at least one of them",
and still don't. Can you put it another way, that I can understand or give
an example of what I must do for it in this case to return a FALSE (for the
2nd If)?

Thanks,


"Niek Otten" wrote:

The second IF contains the construction I mentioned, which always returns TRUE

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jim May" wrote in message ...
| 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
|
|
|