View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kevin Kevin is offline
external usenet poster
 
Posts: 504
Default Trending Function?

I'm trying to have a six month forcast of storage used on a server.

I have range D3:O3 as storage values assigned for 12 months
I have range D2:O2 as the date each of the storage values were pulled.

I would like to have a formula in cells p3,q3,r3,s3,t3,u3 that will give me
a forcast for 1 month out, 2 months etc.

Would I use the Trend formula for that?

Thanks,
Kevin Green