Don't want last number to show.

[john504]

Hello all,
I just finished solving most of the problems creating my 1st check book register. One thing I still can't get is how to stop the number in the formula colum from showing. I saw it done on a tutorial at another sight but I can't get it done for the life of me! I tried not putting in a number before the formula was created but no go either. Anyway when I click and drag down as far as I want to go, I release the mouse button and there it is! The same number all the way down!

Thanks in advance for your help John

PS I see in my info where it says I am using 2012 my error, I am using 2010

[arlu1201]

Please explain a little more? What formula do you have in the cell that you are dragging down?

If you are just talking about a number like 1 that you are dragging down and getting only 1 all the way down your column, then hold the ctrl key and drag down. It should increment by 1 for each cell.

[john504]

I am using the formula that calculates the balance in a check ledger where you sometimes have debit or credit entries. The formul in the balance colum shows the last balance when I click and drag down the colum.

Like if I have $500.00 in the balance and then say make a debit of $25.00. The balance would be $500.00 -25.00=$475.00. Now if I wanted to make the formula useful all the way down the sheet, I would hold down the copy button and drag it down the colum. When I get to the place where I want to stop, I release the button and the colum shows $500.00 continuiosly. When I make a debit it would change to the last balance number like $475.00. and all the numbers down the colum would be $475.00.

[Palmetto]

If we assume:

A2 = amount
B2 = debit or credit
C2 = running balance

You might use:

=IF(A2>0,C1+A2*LOOKUP(B2,{"credit","debit"},{1,-1}),"")

Where C1 contains the starting balance.

The formula checks to see oif A2 contains a value greater than zero (assumes number entries only), if true then check to see if the entry is a debit or credit. If it is a credit the value of C1 is multiplied by 1, if it is a debit the value of C1 is multiplied by a negative 1. In each case the result is added to C1. Because debits are converted to a negative number the balance will decrease.

There are more ways to do this. If the above is not suitable, provide more details about your worksheet or upload a sample workbook (dummy data, of course)