Formula for Calculating Sales Projections

[nirvehex]

Hey all - just a basic question that I'm blanking on for some reason...

I have a pivot table that refreshes that shows me how many units I have sold through out the year with the total units sold in cell F75.

I have another calculation in cell G76 that shows me what % of the way we are through the year.

I'm trying to come up with a formula for how many units I am on pace for. Something like "if we are 50% of the way through the year and I've sold 518 units, how many units am I on pace for, for the year?"

Any thoughts?

Thank you!

 

[PaddyD]

(units sold) / (% of year complete) = (full year projection of units sold)

...assuming sales are evenly distributed through the year

 

[nirvehex]

Thank you!