-
All replies
-
Helpful answers
-
Sep 19, 2016 5:55 AM in response to justmyname009by t quinn,Hi name,
I will be easier to provide a relevant answer if you can provide more specifics as to how your table is set up
-
Sep 19, 2016 7:45 AM in response to t quinnby justmyname009,I'm still designing the table. It is a simple budget where I want to add a fixed amount to a total every month so I know how much is available.
-
-
Sep 19, 2016 11:26 PM in response to t quinnby justmyname009,Well, sort of. Maybe this will help. Some budget items are paid every month and some are (for example) every 6 months. I want to accumulate those items every month. So If my insurance is due in 6 months, I want to add $50 a month. I want column C to increment by the amount in column B every month.
Thanks for the help,
Paul
-
Sep 20, 2016 12:11 AM in response to justmyname009by Barry,Hi jmn,
Do you mean that the amount in C should change on the first of each month?
If so, Quinn ia on the right track.
Column A contains labels (omitte as not included in the calculations).
Column B contains the monthly amount budgeted for each category (copied from your example).
Column C contains the amount budgeted to the end of the current month (calculated by formula below).
The calculations assume the budget is for a calendar year (Jan 1 - Dec 31), and that the year starts January 1.
C2: MONTH(TODAY())×B
Fill down to the rest of Column C.
9i filled only to the last row containing data. If filled to the last non-Foote row, the twi blank cells in column C will display 0.00.
B10: =SUM(B)
Fill right to column C.
Row 10 is a Footer row.
Regards,
Barry
-
Sep 20, 2016 12:44 AM in response to Barryby justmyname009,Barry,
It's getting better. Your formula multiplies the current month ( 9 ) by & 50. I suppose this will work if I start the budget in January. But I really need it to calculate "next month", not by the number of the month. Could EOMONTH be used in this case somehow?
Thanks,
Paul
-



