If and or condition what am I missing

**miketrrap** · 02-03-2009, 05:36 PM

I am a VFP programmer trying to work some VBA but dont have it yet. Excel 2003 if and or conditions

Please Login or Register  to view this content.

Mike

**VBA Noob** · 02-03-2009, 05:51 PM

Thanks for taking the time to read and comply with the rule

.

Looks ok. What's the problem.

VBA Noob

**miketrrap** · 02-03-2009, 06:41 PM

I have posted the file book1
I am getting A's where I should have B's
If I switch the 2 or conditions from "SL-1" to "SL-2" and so on
I get B's where I should have A's
I must have the "or" condition not nested properly?
Mike

**mewingkitty** · 02-03-2009, 06:42 PM

I don't see where it's returning anything incorrectly...

Your code says :

If AD&D is in column Z, and SL-1 or SL-2 are in AA then AB = B

If column Z is blank and column AA <> "" then AB = A

**miketrrap** · 02-03-2009, 06:56 PM

I bet its right in front of me but if z has AD&D and AA has a value I am looking for a B in column AB
if coulumn z is blank (No AD&D) but AA has a value I need a A in column AB
If both z and AA are blank I want a blank in AB.
If I run the code I get a few B's where I should have A's in AB
Hope I explained it correctly
Mike