Excel Formulas aren't calculating correctly

**Suomalainen** · 12-21-2010, 04:26 AM

Hello Everyone!

I have a spreadsheet I created and need some help with it.

Here is a description of the columns in my spreadsheet.

Column Explanation

A = Date in format Day-Month-Year
B = Just a plain number I assign randomly
C = Description of item debited/credited
D = Amount either debited or credited. Amounts are in EURO.
E through I = Additional level of detail that describes item(s) being credited or debited if not listed in column "D".
J = Current balance

Here is what I would like to see happen. I want to be able to enter the date, a random number and a description of an item being debited and/or credited in column "D". If column "D" is not filled than the credit or debit will be entered somewhere between columns "E" through "I". As each row is filled with data the "Current Balance" in Column "J" is always being adjusted accordingly. A column containing a EURO value can be either positive or negative.

If I need to add any additional columns sometime in the future, I would like to have this possibility enabled as well.

Would someone mind instructing me as to what I need to do.

Thank you very much,

Suomalainen

**davesexcel** · 12-21-2010, 05:12 AM

=J2-SUM(D3:I3)
Dragged down
Column C does not indicate debit or credit, the amount does if you use negative or positive numbers.

Please complete your profile properly.

**martindwilson** · 12-21-2010, 05:22 AM

excel formulas nearly always calculate correctly. if it the wrong answer then you are using the wrong formula!

**TMS** · 12-21-2010, 05:41 AM

Maybe (to build on Dave's formula):

=IF(C3="","",N(J2)-SUM(D3:I3))

and drag down. This will allow you to pre-populate cells without the last value being repeated. On the down side, if you have a blank description for any reason, it will get confused.

Regards

**Suomalainen** · 12-21-2010, 07:47 AM

Thank you everyone for helping me! Also, Merry Christmas to all!

I'm real new to excel computer and to PC spreedsheet. Still learning how computer working.

I still have one question. Why in formula I must use negative sign " - " to make value add in Colum "J". Meaning that if I need to add a credit between column D to I I must use the minus sign.. This confuses me.

Is in not possible to use "+" sign when adding a credit and then just plain number to subtract.

I appreciate your explanation.

Thank you very much.