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.
|