+ Reply to Thread
Results 1 to 6 of 6

Need help adding functions to Budget sheet

  1. #1
    Registered User
    Join Date
    05-13-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Question Need help adding functions to Budget sheet

    Hi there, i have created a Budget sheet which works on weekly and monthly basis, showing individual week costs and budget, with profit/loss and a monthly one summing all the values up. The problem i have with this is that every time i open the sheet it keeps giving me an error and i have to update to amend the error. Any fixes for that. (sometimes lots of hashes appear######)

    Another question is, i want to know if there is a formula or a function that allows me to reduce the week budget if the current cost in the monthly sheet has exceeded the budget....ie utilities budget is £150 a week in a month its £750 (5 weeks as a month not 4). if in one week i have gone over the budget will i be able to reduce the following weeks budget equally. so that it does not exceed the maximum budget for the month.

    Thanks in advance, bit of a nooby, know some from secondary lessons, but that wasn't helpful XD.

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Need help adding functions to Budget sheet

    Could you share the exact error notice?

    Also send a dummy sample of your layout so your second request can be worked more easily..

  3. #3
    Registered User
    Join Date
    05-13-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Need help adding functions to Budget sheet

    Circular Reference warning is what pops up and the problem is on the monthly sheet of the excel file. I don't know how to attach sheet????

  4. #4
    Registered User
    Join Date
    05-13-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Need help adding functions to Budget sheet

    Managed to find it
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Need help adding functions to Budget sheet

    in the c column of month you tried to add the cell to itself. In c4 you were adding weekly data and Month!c4. I deleted that part in cells c4,c7,c10 and there are no more circular cells/

    To locate circular references goto formulas error_checking (open the droplist) and click circular reference. it will tell which cell(s)

  6. #6
    Registered User
    Join Date
    05-13-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Need help adding functions to Budget sheet

    Thanks, that was really helpful....That eliminates one problem lol, now i have the second issue of automatically lowering the budget when the monthly cost has exceeded the monthly budget.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1