If Formula Help
 

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)

If Formula Help
 

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)

If Formula Help
 

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)

If Formula Help
 

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)

If Formula Help
 

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)