Formula with mulitple condtions
 

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!

=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!

Lee Wrote:
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(A11000,A1<2000),\"QUARTERLY,\"MON THLY\"))

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.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=470101