In Excel, how do you annualize data?

[JanSanM]

I am keeping a log of cases done per month, and need to annualize each month
to forecase yearly volume. I am looking for the way to build the formula to
Annualize.

 

[Max]

One simple way
Assume monthly figs are progressively entered in B2 across
In C2: =AVERAGE($B2:B2)*12
Copy C2 across to return desired yearly forecast

High-five? Click YES below

P/s: Rather than here, post such questions in excel.worksheet.functions
which is a more appropriate and better attended newsgroup
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik