View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] joeu2004@hotmail.com is offline
external usenet poster
 
Posts: 418
Default calculating wanted cash from overlimit dealing in stock market.

Wafa wrote:
B/S Balance Wanted cash

(63,000.000) (63,000.000) (63,000.000)
12,600.000 (50,400.000) (63,000.000)
(40,000.000) (90,400.000) (90,400.000)
10,000.000 (80,400.000) (90,400.000)
12,000.000 (68,400.000) (90,400.000)
(80,000.000) (148,400.000) (148,400.000)


I think the formula for "Wanted Cash" can be one of the following
(assuming the first -63000 line is row 3 and "Wanted Cash" is column
C):

C3: =IF(A3<0, SUM($A$3:A3), C2)

C3: =if(A3<0, B3, C2)

Copy down column C as needed. The first formula allows you to avoid
the "Balance" column. But since I suspect the "Balance" column is
useful to you, the second formula is the more efficient and
straight-forward, IMHO.