JimmieHowe
New Member
- Joined
- May 16, 2010
- Messages
- 1
I'm trying to create a budget worksheet. I want to be able to enter my expenses and have the sheet tell me how much that expense is for 1 week, 1 month, 6 months, and 1 year.
Let's say I enter Rego - $260 a year. 1 week would be $5, 1 month $20, 6 months $130.
The problem is, the way my sheet is set up at the moment means I have to enter it as a weekly amount, and then the sheet calculates the rest. My formulas are: (assuming 'Weekly' is Cell B2)
for 'Monthly' is =SUM(B2*4)
for '6-monthly' is =SUM(B2*26)
for 'Yearly' is =SUM(B2*52)
This means I have to divide every expense I enter down to a weekly amount, rather than just being able to enter the $260 into the 'Yearly' column and have it work the rest out for me, which forfeits the point of having all these columns rather than just having a weekly column. I want to be able to enter the amount into any one of the columns and the sheet do the rest, as some expenses are weekly, some are monthly, some are yearly, etc
I suck at trying to explain things, please don't hesitate to ask for more info, or even better if someone can tell me where I might be able to upload my sheet so you can look at it and get a better understanding
Let's say I enter Rego - $260 a year. 1 week would be $5, 1 month $20, 6 months $130.
The problem is, the way my sheet is set up at the moment means I have to enter it as a weekly amount, and then the sheet calculates the rest. My formulas are: (assuming 'Weekly' is Cell B2)
for 'Monthly' is =SUM(B2*4)
for '6-monthly' is =SUM(B2*26)
for 'Yearly' is =SUM(B2*52)
This means I have to divide every expense I enter down to a weekly amount, rather than just being able to enter the $260 into the 'Yearly' column and have it work the rest out for me, which forfeits the point of having all these columns rather than just having a weekly column. I want to be able to enter the amount into any one of the columns and the sheet do the rest, as some expenses are weekly, some are monthly, some are yearly, etc
I suck at trying to explain things, please don't hesitate to ask for more info, or even better if someone can tell me where I might be able to upload my sheet so you can look at it and get a better understanding