Assigning negative and positive numbers in a formula

[Tom Richards]

I'm trying to simplify my expenses/income workbook by combining my expenses
page with my income page. Right now my expenses categories number 100 to 299
while my income are 300 to 307. Here are 3 columns from my expenses sheet:

Category - Amount - Total
119 2.97 2.97
126 3.62 6.59
123 0.55 7.14
112 12.86 20.00
123 4.48 24.48
124 4.90 29.38
109 53.61 82.99

What formula do I need to enter in the amount column to assign positive
(income [300-307 from category column]) or negative (expenses[100-299])
values to the number in the amount column?

 

[Andy Brown]

What formula do I need to enter in the amount column ...

??? Surely you need the amounts in the amount column, and formulas in the
total column.

Assuming a starting figure of 0 in C1, use

=IF(A2<300,C1-B2,C1+B2)

in C2 and drag it down to produce a running balance.

HTH,
Andy

 

[Tom Richards]

Thanks for the help Andy. That worked for me.

??? Surely you need the amounts in the amount column, and formulas in the
total column.

Assuming a starting figure of 0 in C1, use

=IF(A2<300,C1-B2,C1+B2)

in C2 and drag it down to produce a running balance.

HTH,
Andy