Excel Formulas and Functions

I need some easy tips on Excel formulas and functions. I am trying to set up a spreadsheet for my bank account. I have columns for debit, credit, account balance, cleard y or n, outstanding. If a check hadn't cleared I will put a "n" and I would like in the outstanding there to be a formula to place the amount of the check(debit)that hadn't cleard. This way I can have an outstanding amount and somehow subtract this amount from the account balance to give me a reconciled amount.