Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need a formula to add numbers to the result in same cell.
I hope this is the correct place to pose this question:
How do I write the formulas for cell C3 and C4 so cells C3 and C4 continue to derive a cummulative total adding the amounts in column C beginning in cell C10? A B C D 1 2 3 Total credits (C3)=If C10=0, then add it to the results currently displayed in cell C3, but. If C10=<0, then add 0 (zero) to the results currently displayed in cell C3. 4 Total debits (C4)=If C10=<0, then add it to the results currently displayed in cell C4, but, If C10=0, then add 0 (zero) to the results currently displayed in cell C4. 5 6 7 8 9 Date Description Amount 10 08/29 Bill (128.42) 11 09/10 Deposit 1232.00 12 09/11 Food (332.00) 13 10/01 Deposit 1232.00 Is this making sense to anyone but me? I just don't know how to do this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
omit numbers past decimal in formula result | Excel Worksheet Functions | |||
Formula Bar F9 Result differs from cell result??? | Excel Worksheet Functions | |||
Format Result of a Formula Combining Text & Numbers | Excel Discussion (Misc queries) | |||
How do I convert formula result into numbers so I can sum results? | Excel Discussion (Misc queries) | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions |