Just a quick take, but I think ",0" should be moved to the left inside the ")".
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
"Jim May"
wrote in message
=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