Thread: Average price.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
chrisnsmith chrisnsmith is offline
external usenet poster
 
Posts: 96
Default Average price.

Column three is a list of commodity prices that are quoted in eighths. The
far right number represents the 1/8 cent quote. Line one would be 560 and
6/8, line nine would be 531 and 2/8 and so on.
What I need to do is average the whole numbers in column C and average the
1/8 separately.

Can someone help?