|
PureBytes Links
Trading Reference Links
|
How about try commas instead of all the semicolons?
Aaron
----- Original Message -----
From: "Trey Johnson" <dickjohnson3@xxxxxxxxxxxxxx>
To: <omega-list@xxxxxxxxxx>
Sent: Tuesday, March 11, 2003 12:04 PM
Subject: Excel Formula
> Hello List,
> In excel, I'm trying to determine the number of periods in a row that a
> move lasts. In column F, I have the ratio of current close to previous
> close, which are in column E. In column G, I'm using the following formula
> =IF(OR(AND(F3>1;F2<1);AND(F3<1;F2>1));1;G2+1). It keeps returning error in
> formula, then highlights the first "1." Anyone know why?
> Thanks in advance,
> Trey
>
>
|