Take a look at Peter Nonely's workbook that describes lots of functions:
http://homepage.ntlworld.com/noneley/

If Peter's site isn't working, but Ron deBruin has a copy at:
http://www.rondebruin.nl/files/xlfdic01.zip

Norman Harker has his version at Debra Dalgleish's site:
http://www.contextures.com/functions.html

Mark P wrote:

Would like a masive list of functions and their purpose to refer to.

--

Dave Peterson