Calculate using IF Statement

[christianbiker]

I want to set up a basic spreadsheet in order to track account activity for our club. The columns I have set up to track the actual money are as follows:
Amount Debited
Amount Credited
Balance

I want it to be an ongoing calculation that will automatically add/subtract based on where the amount fall. It it falls into the debited column i want it automatically removed from the balance column, and if it falls into the credited column i want it to autmatically add to the balance column.

I came up with this formula to minus:
=IF(C6>0, C6+E5, "")

but when i add another IF statement like this in order to add i get an error:
=IF(C6>0, C6+E5, ""), IF(D6<0, E5-D6, "")
it gives me #VALUE.

How do i get around this?

Thanks.

 

[kkknie]

I think you just missed it by a smidge... Try

=IF(C6>0,C6+E5,IF(D6<0,E5-D6,""))

The way the nested if works is:

If (Condition1, Then Sum, Else If (Condition2, Minus, Else Nothing))

Note that if both conditions are true, only the first one will be evaluated.

Hope this helps,

K

 

[priddyboy]

I can't tell what your best options are without seeing your sheet, but try this to combine the two formulas:

=IF(C6>0, C6+E5,IF(D6<0, E5-D6, ""))

 

[christianbiker]

got it...thanks, much appreciated. i figured it was something simple like that.

Chad