Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
In Excel, how do you annualize data?
1,327 views
Skip to first unread message
JanSanM
Feb 23, 2009, 10:18:20 AM2/23/09
to
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.
to forecase yearly volume. I am looking for the way to build the formula to
Annualize.
Max
Feb 24, 2009, 4:55:01 AM2/24/09
to
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
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
---
0 new messages