You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"efuture" wrote in message
...
thank you very much!!! It worked perfectly!!!
My best...

"T. Valko" wrote:

Here's my best guess:

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

--
Biff
Microsoft Excel MVP


"efuture" wrote in message
...
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)