Microsoft Microsoft excel 2007 (pc)

0-4 Less than 1 MOS

5-12 1-3 MOS

13-24 3-6 MOS

25-52 6 MOS - 1 YOS

53 > 1 + YOSI 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

office forum please. Moderator please move. Thanks

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

sorry I posted to wrong forum! Thank you for your help!

Ask Your Question

Weekly Poll