|
|
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-2008
| Updated: | 04/02/2008 19:33 |
| This page added: | 13 January 2005 |
|