Jun 03 2021 01:52 PM - edited Jun 03 2021 01:58 PM
I came to a second formula that I cannot figure out. I got a great resolution to the first one, and I am thinking this will be easier. I am great with the basics but this is beyond me.
SImple enough, and I am using numbers from last month for an example..
Selling Days - 26
Selling Days Completed - 22
Monthly Forecast - 13 units
Delivered MTD - 9
To be on pace for the monthly forecast of 13, I need a formula that gives me the number I should have after the 22 days. In this case, I know it to be 8, 3, 11 top to bottom - I just cannot get there with the spreadsheet)
06/03/2021 | ||||||||||
Selling Days | 26 | |||||||||
Selling Days Completed | 22 | |||||||||
Daily Sold | Month-To-Date | To Be On Forecast* | Month Forecast | |||||||
Delivered | Track % | |||||||||
New | 7 | 83% | ??? | 10 | ||||||
CPO | 2 | 79% | ??? | 3 | ||||||
Total | 9 | 82% | ??? | 13 | ||||||
should be* | ||||||||||
8 | ||||||||||
3 | ||||||||||
11 | ||||||||||
Jun 03 2021 03:04 PM
Hi @baronjosefr ,
It is a little hard to tell from your description what is needed.
However, I think this is the formula you are looking for:
=ROUND(G15*($B$8/$B$7),0)