Formula with mulitple condtions

[Lee]

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!

[BenjieLop]

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!

What happens if A1=1000?

Anyway, try this,

=if(A1<1000,"Semi Annually,if(and(A1>1000,A1<2000),"Quarterly,"Monthly"))

BTW, even if you also do not have anything for A1=2000, the formula above will
return "Monthly" for all values of A1>=2000.



Regards.

[Anne Troy]

=If(a1<1000,"Semi Annually",if(a1>1000,"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" <Lee@discussions.microsoft.com> wrote in message
news:09AF876B-8BCE-4A60-B728-989BF934796E@microsoft.com...
> 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!
>