LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 45
Default Excel Positive/Negative Running Total

I posted a message earlier and have received a partial solution.

I want to keep track of how much stock prices go up or down with a running
total of how much they go up or down over several days until the direction
changes.

The formula I am now using total the first and second day but does not do a
running total count if there are more than two up or down days in a row.
Your help is appreciated.

=IF(SIGN(H3)=SIGN(H4),H3+H4,H3)

However, the example below illustrates what I am looking for ---- column A
are the daily totals and column B is an example of how I want to calculate
the running total:
A B
Row
1 10 10
2 10 20
3 10 30
4 -5 -5
5 -5 -10
6 -5 -15
7 10 10
8 20 30
9 30 60
10 -5 -5
11 15 15
12 15 30

When the number is column A changes from positive to negative or negative
back to positive, I want to adjust column B until it changes again. Is this
possible?

Thanks.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Convert a column of numbers from positive to negative in Excel JRoseen Excel Discussion (Misc queries) 4 July 7th 06 07:18 PM
Indian comma in excel in positive numbers as well as in negative shrinivas Excel Discussion (Misc queries) 1 June 14th 06 02:06 PM
how to interchange positive to negative value in excel RKS Excel Discussion (Misc queries) 2 May 3rd 06 11:57 AM
how to turn positive to negative values in excel Paula1 Excel Worksheet Functions 4 February 23rd 06 10:54 PM
Formula to make Negative Values Positive & Positive Values Negative? mustard Excel Discussion (Misc queries) 4 September 26th 05 10:05 PM


All times are GMT +1. The time now is 01:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"