Formula for ledger
 

Hello,

I have Windows Office/Excel 2003 Professional SP3.

I am trying to figure out a formula for a personal ledger I have.

There are a bunch of debits under a clients name but if the client reaches a
particular threshold they get awarded with additional funds.

EX.
Client A has run up a tab.
So under Client A's Column has a series of debits.
So i simply add up the debits (B3+B24+B45+B65+B85) and subtract from what
they already paid me (B2). End result: (B2-B3+B24+B45+B65+B85) and I put the
end result in B4.

If they reach a threshold I will subtract whatever the amount or award that
is calculated in cell: C50 friom their debt. But If someone else on the same
ledger reaches it first then it goes to the other person.

I basically need an IF formula, I think.

If you can help me with a formula or an array formula I will appreciate it.

Thanks in advance!