Formula with mulitple condtions

L

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

BenjieLop

Lee said:
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!
Click to expand...

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