View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nick Anderson Nick Anderson is offline
external usenet poster
 
Posts: 9
Default Formatting an Excel worksheet

I have a worksheet that we are projecting the total number of policies sold
for 30 days. We need to calculate the run rate for the month to determine how
close we are to matching our goal. For example, we currently have a goal at
15000 policies to sell, we want to know using a run rate based on 11/10/2007
how close we are to our goal right now we are showing a number of 11250 which
if we keep the current trend we are going to be at a goal of 11250 and not at
15000. Can someone please help me with this?