[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

If Then function



PureBytes Links

Trading Reference Links

Tom

I have a degree in mathematics and logic. The If Then statement may also use
an Else but does not require it. The topic is closed as far as I am
concerned.

-----Original Message-----
From: owner-metastock@xxxxxxxxxxxxx
[mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Tom Sprunger
Sent: Wednesday, December 27, 2000 11:01 AM
To: metastock@xxxxxxxxxxxxx
Subject: Re: Need Help On If function


An IF function must have an Else as well as a Then to be logically correct.
It is impossible to  have no Else without violating the rules of logic.  It
would make no sense to either a computer or a human.  I don't believe such a
scenario exists in nature either.  You will have to find some other way to
do what you want.

Tom



----- Original Message -----
From: "neo" <neo1@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: Sunday, December 24, 2000 10:53 AM
Subject: RE: Need Help On If function


> >>>Neo
> The 'If' function is simply a true/false function.
> If, as an example, you wanted to know the volume on up days:
> If(C>O,V,0)
> and you wanted to eliminate the '0' you can simply rewrite the formula as
> V*(C>O)
> This will give you the same result. The true statement returns a 1.
> Therefore
> multiplication of the true expression by the desired result will give you
> the
> desired result and nothing else.
>
> Jim<<<
>
> Jim
>
> Interesting way to look at it but it seems it would result in the same
> problem. If the logical expression is false then the entire expression
would
> return a 0 which is the same problem. I want a simple If Then rather than
an
> If Then Else so that if the expression is not true then nothing would be
> plotted. I think MS needs to add an If Then expression. This way if the
> expression were true then the formula would be executed. If it were not
true
> then nothing would happen rather than have a 0 returned.
>
> Thanks, neo
>