Simple formula
Hey Deb
In D
"Debbie" wrote:
Hi, I am assuming that you have 4 cells (A2,B2,C2,D2 as A1,B1,C1,D1 are Name, Period Actual Spend, Period Budget Spend, and Year to date actual spend). Click on D2 and type in "=B2". This will make D whatever B is. If you don't want that (for example if you want D to reflect B+C than in D2 you type in "=B2+C2".
What formula do I need to use to create a running balance in my budget
spreadsheet i.e. I have 4 columns A = Name, B = Period Actual spend, C =
Period budget spend, D = Year to date actual spend. So I want to be able to
enter a value into B at the end of every month and D will automatically
change.
P.s. I'm a novice so I hope I explained myself ok?
--
Deb
|