Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
budget columns
I need vertical columns automatically subtracting as entries are made with
balance at the bottom, like so: A is text budget items, B / C / & D are Paycheck amounts. As item amounts are entered, should auto subtract to balance cell farther down the column. I've tried all afternoon (actually it's 8:20pm now, so all day) to learn how to do this, not succeeding. Everything is beyond this & going left to right. Those you know, please help. I just want an easy home budget sheet, not a new career. Thanks so much for any help at all. My last math class was in 1970. -- household appliances should run themselves |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
budget columns
Can you provide some sample data with the result you want?
"Jade" wrote: I need vertical columns automatically subtracting as entries are made with balance at the bottom, like so: A is text budget items, B / C / & D are Paycheck amounts. As item amounts are entered, should auto subtract to balance cell farther down the column. I've tried all afternoon (actually it's 8:20pm now, so all day) to learn how to do this, not succeeding. Everything is beyond this & going left to right. Those you know, please help. I just want an easy home budget sheet, not a new career. Thanks so much for any help at all. My last math class was in 1970. -- household appliances should run themselves |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
budget columns
What version of Excel are you using? There are some downloadable budget
templates at Microsoft.com that might be easier than trying to roll your own; depending upon what exactly you're trying to do. You want to SUBTRACT your paycheck amounts from something? What is it that you want them to subtract from and why? -- -Ben- Ben M. Schorr, MVP Roland Schorr & Tower http://www.rolandschorr.com http://www.officeforlawyers.com Author - The Lawyer's Guide to Microsoft Outlook 2007: http://tinyurl.com/5m3f5q "Jade" wrote in message : I need vertical columns automatically subtracting as entries are made with balance at the bottom, like so: A is text budget items, B / C / & D are Paycheck amounts. As item amounts are entered, should auto subtract to balance cell farther down the column. I've tried all afternoon (actually it's 8:20pm now, so all day) to learn how to do this, not succeeding. Everything is beyond this & going left to right. Those you know, please help. I just want an easy home budget sheet, not a new career. Thanks so much for any help at all. My last math class was in 1970. -- household appliances should run themselves |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
budget columns
Thanks so much for responding. Templates I see are too overdone for my
simple purposes and minimal time. I'm wanting formula for this: Bills Paycheck As each amount is filled in, column auto 1,000 subtracts from the paycheck amount, so rent __________ you always have your current balance at hshld __________ bottom of column. visa __________ Thank you for any help at all. Jade. -- household appliances should run themselves "Jade" wrote: I need vertical columns automatically subtracting as entries are made with balance at the bottom, like so: A is text budget items, B / C / & D are Paycheck amounts. As item amounts are entered, should auto subtract to balance cell farther down the column. I've tried all afternoon (actually it's 8:20pm now, so all day) to learn how to do this, not succeeding. Everything is beyond this & going left to right. Those you know, please help. I just want an easy home budget sheet, not a new career. Thanks so much for any help at all. My last math class was in 1970. -- household appliances should run themselves |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum If in a Budget | Excel Discussion (Misc queries) | |||
Conditional SUM for Budget, Actuals, & Variance YTD columns | Excel Worksheet Functions | |||
Budget | Excel Worksheet Functions | |||
Divide Monthly Sales Budget to Day Budget | Excel Worksheet Functions | |||
Sum YTD Budget | Excel Worksheet Functions |