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)
|