help with conditional formula for a group of values

[mike]

I need help with a conditional formula.

Lets pretend A1 has a value of 15 and in the A2 cell I
wish to have a conditional formula that states if the A1
value is greater than > 10 and less than < 20 - if this is
true (which it is) the value will be "dog." If A1 has a
value of 21 then this falls in the "cat" category i need
to add another condition so that if the value in A1 is
greater than >20.1 and less than <28.99 if this is true
than the value input for A2 should read "cat." All false
inputs should read "0" so if the A1 cell has a value of 5
it should read "0." Basically I want the formula to input
a certain word for a value that falls between a set of
numbers.

I've tried all sorts of different ways to make this work
and I cannot make it function properly if anyone can help
it would be very appreciated.

 

[EZ Money]

=IF(AND(A1>=10,B1>=30),"Dog","Cat")

 

[Dan E]

Not exactly the limits your asking for but
=IF(F1<=10, 0, IF(F1<=20, "Dog", IF(F1<29, "Cat", 0)))
produces 0 from 1 to 10 and above 29
produces Dog from above 10 to 20
procuces Cat from above 20 to 29

Dan E

 

[Bob Phillips]

Mike,

Try this
=IF(AND(A1>10,A1<=20),"dog",IF(AND(A1>20,A1<=28.99),"cat",0))
just extend to suit.

You might also want to check your ranges, you have gaps.

 

[Mike]

You are all geniuses!!! Your help is very valuable thanks
so much!!!!