excel formula to produce text

Microsoft Microsoft excel 2007 (pc)
April 1, 2010 at 11:34:52
Specs: Windows XP
0-4 Less than 1 MOS
5-12 1-3 MOS
13-24 3-6 MOS
25-52 6 MOS - 1 YOS
53 > 1 + YOS

I want to write a formula that will look at a cell and if any of the above critera fits give me the wording next to it.

(if(A1>0,=<4),"Less than 1 MOS",if(A1>5,=<12),"1-3 MOS,) ...... I want to put all of the above into a formula.

thanks, Yvonne


See More: excel formula to produce text

Report •


#1
April 1, 2010 at 11:39:29
office forum please.

Moderator please move. Thanks


Report •

#2
April 1, 2010 at 11:54:27
Excel question are best asked in the Office Software forum.

Than being said, try this:

=IF(ISBLANK(A1),"",IF(A1<=4,"Less Than 1 MOS",IF(A1<=12,"1 -3 MOS",IF(A1<=24,"3-6 MOS",IF(A1<=52,"6 MOS - 1 YR","1 + YOS")))))

MIKE

http://www.skeptic.com/


Report •

#3
April 1, 2010 at 11:56:57
sorry I posted to wrong forum! Thank you for your help!

Report •

Related Solutions


Ask Question