Spreadsheet Formulas

Excel VBA
Excel Formulas
User-defined Functions
Excel Links
Access VBA
Access SQL
Alan’s Excel FAQ
Excel Home
Alan’s Home

If Rank is Greater than 10…


=IF(RANK(A2,$A$1:$A$22,1)>10,0,RANK(A2,$A$1:$A$22,1))


© 1996-2008

Updated:  04/02/2008 19:33
This page added:  20 February 1996