Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is this possible | Excel Worksheet Functions | |||
Stock Market data issue | Excel Discussion (Misc queries) | |||
Stock Market Challenge | Excel Discussion (Misc queries) | |||
Calculating market growth rates | Excel Worksheet Functions | |||
access stock market quotations | Excel Worksheet Functions |