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

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,137
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,114,337
Messages
5,547,357
Members
410,786
Latest member
dworkin
Top