Posted to microsoft.public.excel.misc

chrisnsmith chrisnsmith is offline

external usenet poster

Posts: 96

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Average price between dates	PaulinaDi	Excel Worksheet Functions	9	October 7th 08 12:05 AM
Average price between dates	PaulinaDi	Excel Worksheet Functions	1	September 30th 08 11:33 PM
average price	S S	Excel Worksheet Functions	3	April 30th 06 07:26 AM
calculate/convert volume price to monthly average price	Bultgren	Excel Worksheet Functions	2	February 14th 06 09:36 AM
How do I get the average price per bid for an individual month?	matt	Excel Discussion (Misc queries)	5	July 30th 05 11:54 AM

All times are GMT +1. The time now is 05:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us