|
PureBytes Links
Trading Reference Links
|
In a message dated 6/3/00 10:22:28 AM Eastern Daylight Time,
RHunt.066@xxxxxxxxxxxxxxxx writes:
<< Nothing like an Excel challenge to get the gears in motion on a Saturday
morning!
Assuming your data series begins in A1 and runs down the column, the
following formula should be placed in B4 and pasted down.
=SUM(IF(A1>=1,A1,-(1-A1)),IF(A2>=1,A2,-(1-A2)),IF(A3>=1,A3,-(1-A3)),IF(A4>=1,A
4,-(1-A4)))
If you have an exceptionally large data set, it might speed up the
calculations if you place the following in B1 and paste down:
=IF(A1>=1,A1,-(1-A1))
and then put the following in C4 and paste down.
=SUM(B1:B4)
Hope this helps!
Bob Hunt
THE PATTERN TRAPPER
E-Mail: RHunt@xxxxxxxxxxxxxxxxxx
Web Site: http://www.PatternTrapper.com
Phone: 612-892-5550
----------------------------------------------- >>
Thank you so much for your help
have a nice weekend
best regards
Ben
|