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 Samsung's Bixby will compete well against other phone AI systems?

Discuss in The Lounge

Poll History