formula

[lucky7]

my problem:
C1 has the beginning balance
A2 has the amount to add to C1
B2 has the amount to subtract from C1
C2 has the result of adding A2 and subtracting B2

i want to repeat this function thru the entire spreadsheet without having to
copy it cell by cell. any suggestions?

 

[barry houdini]

my problem:
C1 has the beginning balance
A2 has the amount to add to C1
B2 has the amount to subtract from C1
C2 has the result of adding A2 and subtracting B2

i want to repeat this function thru the entire spreadsheet withou
having to
copy it cell by cell. any suggestions?

If you use this formula in C2

=C1+A2-B2

then you can easily drag it down the column as far as required.

If you don't want a value to dispaly until there's at least one valu
in columns A or B on that row then change to

=IF(COUNT(A2,B2),C1+A2-B2,""

 

[Simon Lloyd]

Using barry's suggestion for the formula, once entered simply righ
click and copy, SCROLL to your furthest desired cell, hold down SHIFT
left click once your furthermost desired cell then right click in th
selection and choose paste

my problem
C1 has the beginning balanc
A2 has the amount to add to C
B2 has the amount to subtract from C
C2 has the result of adding A2 and subtracting B

i want to repeat this function thru the entire spreadsheet withou
having t
copy it cell by cell. any suggestions

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com