Ask Experts Questions for FREE Help !
Ask
    Rockmelon's Avatar
    Rockmelon Posts: 4, Reputation: 3
    New Member
     
    #1

    Jan 20, 2008, 09:16 AM
    Running Balances
    I have a spreadsheet set up calculate debits and credits and to update the running balance.

    I would like to have the balance updated after each entry but to NOT continue down the column repeatedly in those cells that have no entries.

    Yes. I CAN pull the formula down as I need to, but I would like it to update without my further action on my part.

    I tried using the IF function but it would not work for me. I told the first empty cell in the running balance column, IF (the two adjacent cells) = Zero then running balance column would be blank. IF (the two adjacent cells were greater than zero, then running balance cell plus amount owed less amount paid = new running balance.

    It didn't work. Is the answer in front of me and I am not seeing it? LOL Thanks for both your time and effort!
    mdosh01's Avatar
    mdosh01 Posts: 64, Reputation: 8
    Junior Member
     
    #2

    Jan 21, 2008, 06:22 AM
    Conditional formatting is one answer. You have 3 columns, one for debits, one for credits and one for the running balance. The running balance contains the formula subtracting the debits and adding the credits to the balance in the cell above.

    So in some cases, where there are no debit or credit entries, the running balance is the same as the cell above it.

    In the running balance column, apply the following conditional formatting (Tools, Conditional Formatting:

    For Condition 1:
    "Cell Value Is" in the first box
    "equal to" in the second box
    "=C2" in the third box, where "C2" is the cell above (the previous running balance)

    Click on "Format..." in the Conditional Formatting box and select the white color in the "Color" box (next to Underline). This assumes you have a white background in the spreadsheet.

    Using the "Format Painter" tool, you can quickly copy this format to all the cells in the column or as you copy the formula to the other cells, the conditional formatting will go with it.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Beginning Balances [ 2 Answers ]

I feel not smart for having to ask this question. I am a new accountant for an existing company that was purchased recently. The new owners told me to put in the existing AR and AP, which I did. Then after their vacation they gave me the beginning balances that they purchased and they...

Adjusting Balances [ 1 Answers ]

How do I adjust a trial balance for unexpired insurance? What accounts would be affected and how do I get the appropriate amount for the debit and credit to those accounts?

Bath tub shower spout & head running water running at same time [ 1 Answers ]

I started with a slight dripping problem(sayko system).i decided to replace all 3 stem assemblies together as they all were about 18 years old.after reassembling the new stems(danko brand),turned on the water supply & checked faucets.hot & cold worked fine but when the shower was turned on,water...


View more questions Search