IF(ISBLANK([Hourly Wage]);"** No Value **";[Hourly Wage])


IF([Department-ID]=6;"Security";
      IF([Department-ID]=5;"Marketing"; 
         IF([Department-ID]=4;"Manufacturing";
             IF([Department-ID]=3;"Management";
                IF([Department-ID]=2;"IT";
                   IF([Department-ID]=1;"Accounting";"Unassigned")
                )
            )
         )
      )             
  )