Formula to calculate totals

**deb0and** · 02-04-2009, 02:22 PM

Hi

This is probably really easy to do, but i am struggling to get it to work.

My scenario is i have 3 columns

1st - Hours Added
2nd - Hours deducted
3rd - subtotatal

when a figure is typed in column 1 i would like ti to populate in the balance, then when a some hours are deducted for the balance column to reflect that

**DonkeyOte** · 02-04-2009, 02:27 PM

C6: =N(C5)+(A6-B6)
copied down as required

not quite sure of your sample calcs though... surely 6+6 = 12... or are you an accountant ;-)

**deb0and** · 02-04-2009, 02:36 PM

Yeah, slight mistake there

How embarrassing

The formula doesn't work? Maybe i am doing something wrong?

thanks

**deb0and** · 02-04-2009, 02:42 PM

Ok, the formula works great. Thanks, however i have attached the spreadsheet as it will be clearer, how can i get the formula column to stay blank without all those number '9' going down the column?

Is it possible to have them blank and only populate when figures are entered in columns 1 & 2?