In Excel, how do you annualize data?
 

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.

In Excel, how do you annualize data?
 

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
---
"JanSanM" wrote:
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.