Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with if statement
If cell A5 C5 = then Yes, otherwise No, But before it gives Yes it should
look at date (Cell A10 and compare with cell B10) cell A10 must be with the B10 date. A10 = 10/17/2008 B10 = (10/1/2008 - 10/31/2008) All help totally appreciated. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with if statement
Hi,
Are you saying you have 2 dates in B10 and you want to check that a10 is between these dates? If you do have 2 dates in B10 how are they arrived at because if you do have 2 dates in the cell and you have typed them then a comparison is a lot more complicated than it need be. Mike "Yossy" wrote: If cell A5 C5 = then Yes, otherwise No, But before it gives Yes it should look at date (Cell A10 and compare with cell B10) cell A10 must be with the B10 date. A10 = 10/17/2008 B10 = (10/1/2008 - 10/31/2008) All help totally appreciated. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with if statement
Yossy wrote:
If cell A5 C5 = then Yes, otherwise No, But before it gives Yes it should look at date (Cell A10 and compare with cell B10) cell A10 must be with the B10 date. A10 = 10/17/2008 B10 = (10/1/2008 - 10/31/2008) All help totally appreciated. Thanks =IF(AND(A5C5,A10=DATEVALUE(MID(B10,2,FIND("-",B10)-3)),A10<=DATEVALUE(SUBSTITUTE(MID(B10,FIND("-",B10)+2,12),")",""))),"YES","NO") |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with if statement
Hi,
The key to solving this problem is to know what you actually have in B10: (10/1/2008 - 10/31/2008) or 10/1/2008 - 10/31/2008 Before we get carries away, I notice that this represents October. You can make your task easier if you enter October or Oct in cell B10 if you are trying to indicate a whole month. Or better yet enter 10/1/2008 and format it to show Oct-2008. In this last case the formula would be =if(AND(A5C5,MONTH(A10)=MONTH(B10)),"Yes","No") -- Thanks, Shane Devenshire "Yossy" wrote: If cell A5 C5 = then Yes, otherwise No, But before it gives Yes it should look at date (Cell A10 and compare with cell B10) cell A10 must be with the B10 date. A10 = 10/17/2008 B10 = (10/1/2008 - 10/31/2008) All help totally appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF statement with AND statement | Excel Discussion (Misc queries) | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions | |||
If statement and Isblank statement | Excel Worksheet Functions | |||
Help please, IF statement/SUMIF statement | Excel Worksheet Functions |