Thread: Average Range
View Single Post
  #1   Report Post  
Old October 27th 04, 06:00 PM
Stndt
 
Posts: n/a
Default Average Range

Does Excel (2003)have a way to calculate Average Range?
My problem is:
B2:M2 is avg. low price for the year in months
D2:M2 is avg. high price
in C2 to M2 I'd like a formula to calculate Avg. range to
construct a Float Chart of Avr. Range?

Thanks