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

[RT] Re: excell question



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