A Newbie "How To" Question...

DarcyIII

New Member
Joined
Mar 7, 2019
Messages
1
Hi All,

Brand new here and hoping you can help ;o)

I have a simple weekly budgets spreadsheet that also tracks the actual sales values. What's the best way to recalculate the remaining budgets as the actuals come in? Basically, if the cummulative weekly actuals vs budgets are negative, take the shortfall and distribute it across the remaining weeks. I don't know if there is a technical name for this - any help would be awesome ;o)

Thanks
D
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,111
Office Version
  1. 365
Platform
  1. Windows
Essentially the calculation is (Budget - Actual) / Remaining Weeks. How you do that depends on the setup of your sheet.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,456
Messages
5,528,868
Members
409,842
Latest member
mfernandezcean
Top