|
PureBytes Links
Trading Reference Links
|
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
|