Here is a link on how to do nested IF statements.

http://www.techonthenet.com/excel/macros/if_custom.php