Assigning month to number

[Guest]

I have the following formula =IF(B5>B11,B11/B3). What I want to do is for
the result to display as a month, for example if result is 10 I want October
to display, if 11 then November. Is there a way to do this?
Thanks,
Marta

 

[Don Guillett]

try
=TEXT(DATE(2004,yourformula,1),"mmmm")

 

[Don Guillett]

if(myformula>13,"",goodformula)

 

[Frank Kabel]

Hi
with Don't formulaa the result can NEVER be >12

 

[Frank Kabel]

Hi
do you mean
=IF(B11/B3>13,"",TEXT(DATE(2004,IF(B5>B11,B11/B3),1),"mmmm"))

 

[Don Guillett]

We aim to please