| 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) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
