Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,059
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
countifs with multiple dates majestyk Excel Worksheet Functions 2 February 10th 09 08:31 PM
finding multiple code dates for multiple item number kmc Excel Worksheet Functions 3 February 6th 09 11:27 PM
Multiple Sheet, Multiple Criteria Look-Up Function Help Dan Oakes Excel Worksheet Functions 5 December 29th 06 02:37 PM
multiple sumproduct with dates creativeops Excel Worksheet Functions 2 September 7th 06 09:33 PM
Countif on multiple dates Jim Excel Worksheet Functions 6 December 13th 05 06:56 PM


All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"