Have a look at this similar thread in which I tried to provide a detailed explanation - hopefully it gives you the info you want ?

http://www.excelforum.com/excel-2007...-function.html