Do you mean

=IF(AND(A2=1,A2<=30),A2,0)
--
If this post helps click Yes
---------------
Jacob Skaria


"efuture" wrote:

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)