Results 1 to 6 of 6

Budget versus actual formula

Threaded View

Norah Budget versus actual formula 06-05-2010, 06:16 PM
Palmetto Re: Budget versus actual... 06-05-2010, 06:30 PM
Norah Re: Budget versus actual... 06-05-2010, 07:09 PM
shg Re: Budget versus actual... 06-05-2010, 07:39 PM
Norah Re: Budget versus actual... 06-06-2010, 11:01 PM
royUK Re: Budget versus actual... 06-07-2010, 01:09 AM
  1. #1
    Registered User
    Join Date
    06-05-2010
    Location
    Ames, United States
    MS-Off Ver
    Excel 2003
    Posts
    3

    Budget versus actual formula

    Have a spreadsheet with column headers for each month and row headers of budget items (such as electricity expense) as well as a column for the monthly budget figures for each expense item. Each month I enter the individual expense item figures and it automatically sums the row of figures and puts it in the cell to the right in the column labelled "Actual Year-to-Date".
    My problem is what formula do I put in the cells with the column marked "Budget Year-to-Date" because each month it would be different. Right now I use a formula that multiplies the cell that contains the monthly budgeted amount for the item times the number of months that have gone by, so each month I need to remember to change the number of months and copy the formula down the column. For example instead of B3*5 for May, in June, I will need to change the formula to B3*6. There must be a better way to do this!
    Last edited by Norah; 06-07-2010 at 12:05 PM.

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