Second Needed Formula, This Time For Forecasting

[baronjosefr]

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

[#2]

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)