I'm trying to learn Excel on my own. All goes well until I try to insert the formula. I have no idea where to put it. My columns are titled: A: DATE, B: CK #, C: PAYEE, D: DEPOSITS, E: CKS/CHGS AND F: BALANCE. Under that I have "Beginning Balance, and the figure in the BALANCE column.
I think I know what the formula should be, but where do I put it?
Thanks for any help.
Catty (wandering around among the cells)
Posts: 3826 | Location: Olympia, WA, USA | Registered: 06-04-02
To write the formula, either double click the cell you want to put it in, or click in the long text box below all the buttons that are at the very top and type it there. Don't forget to type the = sign before any formula.
Does that help?
Posts: 6525 | Location: Grayson, Georgia, USA | Registered: 06-03-02
Here is a free Excel tutorial, including a description and screenshot of the formula bar. You can find many more free tutorials for Excel and other programs by doing an Internet search.
Posts: 1176 | Location: California | Registered: 06-03-02
Well, sorta. Actually, what I wanted to know was where to put it, but I have since learned that. For the benefit of those of you who are as dense as I am, it goes in the cell where you want the result to appear. Not in the "beginning balance" cell, but the one below, where you have entered a check or a deposit or both.
Thanks for answering, jusork. And thank you, MsSueM, too, for that link.
Catty
Posts: 3826 | Location: Olympia, WA, USA | Registered: 06-04-02