=If(a1<1000,"Semi Annually",if(a11000,"Quarterly","Monthly")))
However, you should decide which side to put exactly 1000 on, and what
happens if a1 is 0 or less?
Maybe this will help:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"Lee" wrote in message
...
What formula could I use to include all of the following condtions?

If < 1000 then Semi Annually
If 1000<2000 then Quarterly
If 2000 then Monthly

I really hope someone can help with this!