Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Discussion (Misc queries) > Compound If, And Or - can
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 477
Default Compound If, And Or - can
=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
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 3,290
Default Compound If, And Or - can

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
Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 3,101
Default Compound If, And Or - can
),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
Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 477
Default Compound If, And Or - can
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
Reply With QuoteReply With Quote
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 3,101
Default Compound If, And Or - can
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
Reply With QuoteReply With Quote
  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 477
Default Compound If, And Or - can
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
Reply With QuoteReply With Quote
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 3,101
Default Compound If, And Or - can
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
Reply With QuoteReply With Quote
  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 477
Default 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
Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
compound tikchye_oldLearner57 Excel Discussion (Misc queries) 4 November 26th 06 10:11 AM
Compound interest Robert Tracey Excel Worksheet Functions 1 November 30th 05 12:27 AM
Compound Interest Ron D. Excel Worksheet Functions 1 March 10th 05 08:45 PM
Compound Interest Paul Excel Worksheet Functions 3 March 8th 05 03:55 PM
compound rate Dr. Sachin Wagh Excel Discussion (Misc queries) 4 March 2nd 05 05:21 PM


All times are GMT +1. The time now is 06:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement