Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Logical Functions

 

Combine IF, AND and CHOOSE to display month name

Input the formula: =IF(AND(A1>0,A1<13),CHOOSE(A1,"January", "February","March", "April", "May", "June", "July","August", "September", "October", "November", "December"),"That is not a month!")