Spreadsheet Formulas

css navigation by Css3Menu.com

Four Conditions

If less than 12, then A*C; else IF greater than or equal to 12 AND less than or equal to 71, then A*D; else IF greater than or equal to 72, then A*E
=IF(A16<12,A16*C16,IF(AND(A16>=12,A16<=71),A16*D16,IF(A16>=72,A16*E16)))

This is also a good example of using the AND function.

© 2005-2017

Updated:  11/07/2017 18:44
This page added:  13 January 2005