| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving a line chart data point revises data table value in Excel ' | Charts and Charting in Excel | |||
| Email (LDAP) data download into a single Excel cell - data separat | Excel Worksheet Functions | |||
| Annualize/ Estimate year-to-date from monthly expense | Excel Worksheet Functions | |||
| I want to convert word column data to excel row data to sort addre | Excel Discussion (Misc queries) | |||
| How do I annualize a standard deviation | Excel Discussion (Misc queries) | |||
Linear Mode
