If Formula Help

[efuture]

I am trying to create a formula that will help pull information from column a
(number of days) and return the data in colum b if it falls within certain
numbers parameters if true or enter a zero if false. Colum a numbers range
from -60 to 500. This is for an aged trial balance. I can't figure how to get
my if formula to take in a group of numbers such as 1-30. I have tried 1:30.
HELP~~~
Here is the formula that I have tried:

=IF(A2=1:30,B2,0)

 

[T. Valko]

Here's my best guess:

=IF(AND(A2>=1,A2<=30),B2,0)

 

[Jacob Skaria]

Do you mean

=IF(AND(A2>=1,A2<=30),A2,0)

 

[efuture]

thank you very much!!! It worked perfectly!!!
My best...

 

[T. Valko]

You're welcome. Thanks for the feedback!