Formula with mulitple condtions

[Guest]

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!

 

[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/if_statements_in_formulas_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com

 

[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.