Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Date range formula
I need a formula that works like this. Cell A1 has a name Cell B1 has a date Cell C1 has a number If Cell A1 has a specific name and Cell B1 is do not exceed date, Cell D1 is populated with C1. For B1, it would be a date prior to 7/22/06, where 7/21/06 or 7/22/06 would populate D1, but 7/23/06 would remain blank in D1. Please help. -- Phatbob ------------------------------------------------------------------------ Phatbob's Profile: http://www.excelforum.com/member.php...o&userid=34371 View this thread: http://www.excelforum.com/showthread...hreadid=541494 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Date range formula
"Phatbob" wrote in
message ... I need a formula that works like this. Cell A1 has a name Cell B1 has a date Cell C1 has a number If Cell A1 has a specific name and Cell B1 is do not exceed date, Cell D1 is populated with C1. =(A1="Name")*(B1<=Now())*C1 For B1, it would be a date prior to 7/22/06, where 7/21/06 or 7/22/06 would populate D1, but 7/23/06 would remain blank in D1. I don't understand what you mean. Bruno |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Date range formula
If my cut off date was 7/22, any date before or on that date, i.e. 7/22, 7/21, 5/30, etc., would populate Cell D1 with the number that is in Cell C1. Does that help? -- Phatbob ------------------------------------------------------------------------ Phatbob's Profile: http://www.excelforum.com/member.php...o&userid=34371 View this thread: http://www.excelforum.com/showthread...hreadid=541494 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Date range formula
In addition to the last clarification, I need to be able to only populate Cell D1 if both the name and date range constraints are met. -- Phatbob ------------------------------------------------------------------------ Phatbob's Profile: http://www.excelforum.com/member.php...o&userid=34371 View this thread: http://www.excelforum.com/showthread...hreadid=541494 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Date range formula
Ok I am sure there is a better solution than this - but this is the sort of thing I would come up with in my long way round of doing things! In A1,B1 and C1 I would have the data as you have detailed. I would also add E1 to be the latest possible date - in your case e1 would be 07/23/06 in D1 I would then use the formula =IF(AND(A1="Name",B1<$E$1),C1,"") where you can replace NAME with whichever word/name you want it to be. You don't need to copy the value in e1 down the range as the formula will always look back at this same date. Sure someone on here will be able to think of a more concise version - but that's the solution I wouls use personally. Might learn something new myself too!! :) Hope that was of some help though! I need a formula that works like this. Cell A1 has a name Cell B1 has a date Cell C1 has a number If Cell A1 has a specific name and Cell B1 is do not exceed date, Cell D1 is populated with C1. For B1, it would be a date prior to 7/22/06, where 7/21/06 or 7/22/06 would populate D1, but 7/23/06 would remain blank in D1. Please help -- mr_teacher ------------------------------------------------------------------------ mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352 View this thread: http://www.excelforum.com/showthread...hreadid=541494 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to look up and return smallest date from a range of dates | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
overtime formula based on dynamic date range? | Excel Worksheet Functions | |||
Match function...random search? | Excel Worksheet Functions | |||
use a date range as criteria in a countif formula | Excel Worksheet Functions |