Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
compound | Excel Discussion (Misc queries) | |||
Compound interest | Excel Worksheet Functions | |||
Compound Interest | Excel Worksheet Functions | |||
Compound Interest | Excel Worksheet Functions | |||
compound rate | Excel Discussion (Misc queries) |