Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Going nuts on this one...
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Going nuts on this one...
? 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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" wrote in message ... ? 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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Going nuts in Excel 2003 | Excel Discussion (Misc queries) | |||
Help! Excel Has Gone Nuts! | Excel Discussion (Misc queries) | |||
My Boss is nuts | Excel Worksheet Functions | |||
Need Help, this is driving me nuts | Excel Discussion (Misc queries) | |||
This drives me nuts | Excel Programming |