Reading Excel Formula...please help

I would really appreciate if anyone can please let me know how to read the following formulae:

=INDEX('Agent Metrics'!A:T,MATCH(TEXT(C8,"0"),'Agent Metrics'!B:B,0)+COUNTIF('Agent Metrics'!B:B,TEXT(C8,"0")),12)

=IF(ISERROR(INDEX(Stats!$A:$I,MATCH($Q11,Stats!$A:$A,0),9)),0,INDEX(Stats!$A:$I,MATCH($Q11,Stats!$A:$A,0),9))/100

THANK YOU IN ADVANCE.
Sara.

Hi Sara,

INDEX, in the syntax used here, returns references to groups of cells which match some selction critera.

'Agent Metrics'!A:T, tell excel to look in a worksheet called 'Agent Metrics', you may be able to see a sheet called this in the tabs at the bottom of the screen. 'A:T' tells excel to search columns A through to T.

MATCH(TEXT(C8,"0"),'Agent Metrics'!B:B,0) tells Excel to find the first cell in column B in the 'Agent Metrics' metics which matches the number in cell C8

COUNTIF('Agent Metrics'!B:BTEXT(C8,"0")) returns the number of all cells in column B of the 'Agent Metrics' sheet which contain the value of C8

Match and CountIf are summed (+), so Index will find a row in 'Agent Metrics' sheet which is the row of the first cell matching C8 plus all the number of cells matching C8 in column B

12) - the twelth column ("L")

So you will get a value from column L based on the number of cells in column B match the value of cell C8 and the relative poisition of the first cell in column B holding this value.

---------------------
From the description above I hope you can see that the INDEX function in the second statement is also going to return a valur from column I ( the ",9" bit at the end) on the 'Stats' worksheet, based on the first cell in 'Stats' column A matches the value of cell Q11.

The ISERROR traps the possibility that INDEX could return any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!).

IF syntax is IF (condition, is true then, else condition is false) for example:
IF(1>2, "you broke the laws of physics", "the laws are safe") would return "the laws are safe"

So IF(the index returns an error, then cell value = 0, else cell value is the result of the INDEX function.

The result of the IF is then divided by 100, and this is dangerous as it could result in 0/100! you may need to move the "/100" inside the final right parathesis ")".

HTH

Art