run rate

  1. I

    AVERAGEIFS formula adjustment to replace a number within the range

    Currently I am using a formula to calculate the last 7 days average to then use that average to project data as a run rate for the remaining days of the month. My current method is hindered due to if there is a slowdown in business (ie. Holiday, shutdown, etc.) the run rate will skew heavily...
  2. R

    Need a more automated formula for estimating a 2 month run rate

    Hello, Hopefully someone can help me here. I'm in the process of automating a report that gets written and I'm down to one final formula that I need help with. Currently I use this formula to calculate a 2 month run rate =(((N14/1)*5)+O14)/2 The '5' represents the number of weeks left in a...
  3. R

    Run rate Weighted Formula

    Help! I am having trouble making a weighted formula for a run rate.. If Number of days Passed (B4)<=15 each day should be weighted at .053 (1st 15days total .8) and if >15 then each days should be weighted at .364( last weeks totals .2) My run rate formula is MTD/number of days passed* number...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top