Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple value if function using dates
Have Today() (08/27/2009) in A1, have a date in D9 (09/04/2009) and another
date in E9 (09/11/2009). If A1 is less than D9, then I want F9 = G9 If A1 is greater than D9 but less than E9, then I want F9 = H9 If A1 is greater than both D9 and E9, I want F9 = I9 Using Excel 2003 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple value if function using dates
"latsyrc57" wrote:
If A1 is less than D9, then I want F9 = G9 If A1 is greater than D9 but less than E9, then I want F9 = H9 If A1 is greater than both D9 and E9, I want F9 = I9 In F9, perhaps: =IF(A1<D9, G9, IF(AND(A1D9,A1E9), I9, H9)) You did not cover the case when A1=D9 and the case when A1D9 and A1=E9. I interpreted your second condition (returning H9) as: if A1 is equal to D9, or if A1 is greater than D9 and A1 is less than or equal to E9. Is that right? ----- original message ----- "latsyrc57" wrote in message ... Have Today() (08/27/2009) in A1, have a date in D9 (09/04/2009) and another date in E9 (09/11/2009). If A1 is less than D9, then I want F9 = G9 If A1 is greater than D9 but less than E9, then I want F9 = H9 If A1 is greater than both D9 and E9, I want F9 = I9 Using Excel 2003 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple value if function using dates
Thank you - this gives me what I needed!
"JoeU2004" wrote: "latsyrc57" wrote: If A1 is less than D9, then I want F9 = G9 If A1 is greater than D9 but less than E9, then I want F9 = H9 If A1 is greater than both D9 and E9, I want F9 = I9 In F9, perhaps: =IF(A1<D9, G9, IF(AND(A1D9,A1E9), I9, H9)) You did not cover the case when A1=D9 and the case when A1D9 and A1=E9. I interpreted your second condition (returning H9) as: if A1 is equal to D9, or if A1 is greater than D9 and A1 is less than or equal to E9. Is that right? ----- original message ----- "latsyrc57" wrote in message ... Have Today() (08/27/2009) in A1, have a date in D9 (09/04/2009) and another date in E9 (09/11/2009). If A1 is less than D9, then I want F9 = G9 If A1 is greater than D9 but less than E9, then I want F9 = H9 If A1 is greater than both D9 and E9, I want F9 = I9 Using Excel 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countifs with multiple dates | Excel Worksheet Functions | |||
finding multiple code dates for multiple item number | Excel Worksheet Functions | |||
Multiple Sheet, Multiple Criteria Look-Up Function Help | Excel Worksheet Functions | |||
multiple sumproduct with dates | Excel Worksheet Functions | |||
Countif on multiple dates | Excel Worksheet Functions |