Spreadsheet Formulas
Excel VBA
Excel Formulas
User-defined Functions
Excel Links
Access VBA
Access SQL
Alan’s Excel FAQ
Excel Home
Alan’s Home
Six Nested Ifs
=IF(U14>=10,6,IF(U14>8,5,IF(U14>5,4,IF(U14>3,3,IF(U14>=1,2,IF(U14<1,0))))))
© 1996-2008
Updated:
04/02/2008 19:33
This page added:
15 January 1996