I am using xp Home edition, and excel 2002. I have a spread sheet for my
accounting that while I put data in the cells the formula will change in
selected cells. I have across the top marked into 1st,2nd,3rd,4th,5th weeks.
In the cells going down I have different accounts the income is given credit
for. In this formula it is set up =sum(A1:E1)-F1+H1. The E1 inside the( )
will change when I put the amount spent from the account. I am not using a -
sign with the spent figure, being it is in the formula. the formula will
change the E1 to F1 when I click enter or the up or down arrows.
CAN ANYONE HELP?