Re: Going nuts on this one...

Thanks very much Tom,

Much appreciated. I was able to work this out eventually, but I had to
rearrange the structure of all the logic.




"Tom Ogilvy" <twogilvy@xxxxxxx> wrote in message
news:OZrc3wvJHHA.4112@xxxxxxxxxxxxxxxxxxxxxxx
? true and false and false or true
True
? true and false and true or false
False

I believe it evaluates from left to right, to in the first case

True and False is False then

False and false = False

then
false or true = True
so true is the result

in the second case

True and false = False
False and true = False
False or False = False

Probably need to be specific

If (UCase(z(i, 1)) <> "CS" And UCase(z(i, 1)) <> "") And
(UCase(.Cells(intPos,
8)) = "CS" Or UCase(.Cells(intPos, 8))) = "" Then


or whatever you intent is.

--
Regards,
Tom Ogilvy



"AD108" <ariel.dugan7654321@xxxxxxxxx> wrote in message
news:Oj55IfvJHHA.3936@xxxxxxxxxxxxxxxxxxxxxxx
I can't figure out why the following expression is evaluating to True when
UCase(z(i, 1)) is equal to ""
What am I missing here. Thanks in advance for any help.

If UCase(z(i, 1)) <> "CS" And UCase(z(i, 1)) <> "" And
UCase(.Cells(intPos, 8)) = "CS" Or UCase(.Cells(intPos, 8)) = "" Then







.

Relevant Pages

  • Re: Meet
    ... I really think we should rearrange ... the entire meet so we can all go to it without missing Dr Who. ... episode of the new series was a tad disappointing? ... Steve Hague ...
    (uk.religion.christian)
  • Re: Meet
    ... I really think we should rearrange the ... entire meet so we can all go to it without missing Dr Who. ... "Beer is living proof that God loves us and wants us to be happy" Benjamin Franklin. ...
    (uk.religion.christian)
  • Re: Single User Setup
    ... Pay no attention to how xp is set up to start with. ... rearrange everything back to win 98 or win me and see what happens. ... missing this and missing that. ...
    (microsoft.public.windowsxp.newusers)
  • Re: Meet
    ... I really think we should rearrange the entire meet so we can all go to it without missing Dr Who. ... But it's not the same when you're watching it 5 hours later on a video, knowing this is 5 hours after the time when God, according to His divine plan, intended you to watch it. ...
    (uk.religion.christian)