"or" function in Excel?

Hi guys, first time here - sorry another newbie!

Ok so as a novice user, I'm trying to build a simple financial statement sheet to keep track of how the wife is spending my hard earned money (she's already doing a wonderful job by the way)

If you'd be so kind as to offer some assistance with the following, I'd be most grateful:

I'd like to have a "Credits" column, and a "Debits" Column, which either adds to or subtracts from my existing balance column. Obviously I'm not going to use both at the same time, but is there a way I can tell Excel - use either +A3 "OR" -B7 to calculate my balance?

I hope this makes sense ?

Thanks in advance.

Regards,
Steve

Welcome to the board
you could eventually use an IF function depending on some condition.

On the other hand you will find lots of free programs on the net for family budgetting;

HTH

Hmmmm . . . . . an "IF" command?

Could you explain a little more . . . maybe with an example?

Thanks,
Steve

On which condition should your choice of +a3 or -b7 be based?

Maybe I'm going at thsi the wrong way - currently I've simply used the following formula:

G7-B3+B4

This gives me my correct current balance, if I enter either a "Debit" value in B3, or a "Credit" value in B4 (with my previous balance in G7).

I think I was hoping to have my formula decide something I didn't need as I look back at it now. I was trying to get the formula to decide either -B3 "OR" +B4, but the way I've currently set it up seems to work fine, providing I don't enter values in both B3 "AND" B4.

If there's another way to set up a bank statement worksheet, I'd be very interested in taking a look to see how other's have done it - but for now I think I've sorted my problem out in a reasonable way (for me anyway).

Thanks for the input though, very much appreciated!

Regards,
Steve

Thx for the feedback Steve

. . . . and thankyou for your help too . . . . discussing these problems on forums such as these, often helps us resolve them ourselves!

Have a great weekend!

Kind regards,
Steve