Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |