Excel Hangs when using Offset in formula. A bug?

[Bart]

If interested, this is usually written as:

Not (x Imp y)
(a little easier to follow for computer geeks)

...at first sight not really for me. So probably then I'm not a
computer geek.
I looked up the definition. I wasn't really convinced. Ok, I did
understand what it practically does, but then what does mean:

True implies False is not True?

Searching Wikipedia I found out about: the Material Condition (http://
en.wikipedia.org/wiki/Material_conditional). The Imp operator implies
something like this:

If A is true, then B has to be true as well. If not: the statement is
false. (A is an antecedent, B is a consequent)

(I'm not really good remembering things just by heart, unless I've
some background information as a reminder.)

Though, just as aside info:

"Did you also know that the two very rarely used VB 6 operators Imp
and Eqv have disappeared in VB.NET, but two new operators, AndAlso and
OrElse have appeared? To replace the missing operators, the VB.NET
documentation suggests that you simply use the standard operators to
accomplish the effect of Imp and Eqv. Here's Imp in code as an
example.
Result = A Imp B 'True unless A True and B False
Result = (Not A) Or B 'Same as A Imp B
The two new operators in VB.NET, AndAlso and OrElse, are used to short-
circuit a logical evaluation by evaluating the second expression only
if it's necessary. This is a way of thinking about expression
evaluation that is familiar to C programmers but new to VB
programmers."

Source: http://visualbasic.about.com/od/usingvbnet/l/bldykand_or_not.htm

Thanks Dana DeLouis! All these things: they are interesting matter.

Bart

 

[Dana DeLouis]

"Did you also know that the two very rarely used VB 6 operators Imp

and Eqv have disappeared in VB.NET, but two new operators, AndAlso and
OrElse have appeared?

Hi. No I didn't. Thanks. That's interesting.
Looks like a great idea. The current IIF function was a good idea, but
since it evaluates both sides, it is very slow and not used very often.
This looks like a great replacement for IIF.
As a side note, I really think Microsoft should just go ahead and support
all the standard functions like Imp. How hard can it really be to include
it??

 

[Bart]

NickHK,
Already I used the bit Flag method in other situations. I like this
compact storage of flags. Before I was imagining how to realize a way
storing the flags using a collection or Array. Then each flag (item)
had to be checked apart. Now I can check if all flags are set with
just one If statement. Brilliant!

Bart