LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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
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
omit numbers past decimal in formula result DebC Excel Worksheet Functions 6 September 25th 08 06:19 PM
Formula Bar F9 Result differs from cell result??? Aaron Excel Worksheet Functions 3 May 15th 08 06:32 PM
Format Result of a Formula Combining Text & Numbers Brad Excel Discussion (Misc queries) 3 April 3rd 07 10:42 PM
How do I convert formula result into numbers so I can sum results? Barsha Excel Discussion (Misc queries) 1 November 11th 06 07:18 PM
Advanced formula - Return result & Show Cell Reference of result Irv Excel Worksheet Functions 7 May 6th 06 03:36 AM


All times are GMT +1. The time now is 08:58 AM.

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

About Us

"It's about Microsoft Excel"