I have a spreadsheet for working out hours worked that ends like this.....

Total Hours _
Add Credit brought forward _
Deduct debit BF _
Total Hours for the week _
Less Standard hours - 36
Total _

What i need to do is forward this balance to another copy of this sheet
using a formula that says if its a positive number then it goes to the credit
cell but if its a negative number then it goes to the debit cell.

Hope this makes sense. If not please ask - I need help.

Thanks
Debi