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

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History