Thread: Interactive formulas
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default Interactive formulas
"Arvi Laanemets" wrote...
=STDEV(OFFSET($D$6,,,$X$1,1)*SQRT(252)
....

OFFSET is a volatile function, so it recalcs all the time. One nonvolatile
alternative would be

=STDEV($D$6:INDEX($D:$D,$X$1+5))*SQRT(252)


Reply With QuoteReply With Quote