| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Math if then
I am trying to return a dollar amount due if the date in one cell is greater
than or equal to today. I'm using this formula in an blank cell: IF(today() = A7 , C7=10,,) Can't get it to work. Using Excel 2003. Help please. Hank |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date Math if then
Hank wrote: I am trying to return a dollar amount due if the date in one cell is greater than or equal to today. I'm using this formula in an blank cell: IF(today() = A7 , C7=10,,) Can't get it to work. Using Excel 2003. Help please. Hank try this put this formula in C7 = IF(TODAY()=A7, 10,) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date Math if then
Hank is correct by moving the formula to C7 and correcting the syntax. You
could also add a pair of quotes after the last comma to suppress the 0 and have a blank cell result when it is not "10". If it still does not behave as expected, you might need to reverse the logical test: IF(TODAY()=A7, 10,"") applies 10 if date in A7 is today or a future date IF(TODAY()<=A7, 10,"") applies 10 if date in A7 is today or a past date From your written description it seems like your logical test is backwards. However if the 10 represents a late fee for example, then the formula is right and the description is misleading me. Roy "stevebriz" wrote: Hank wrote: I am trying to return a dollar amount due if the date in one cell is greater than or equal to today. I'm using this formula in an blank cell: IF(today() = A7 , C7=10,,) Can't get it to work. Using Excel 2003. Help please. Hank try this put this formula in C7 = IF(TODAY()=A7, 10,) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date Math if then
oops! change that to: stevebriz is correct...
"Roy Wagner" wrote: Hank is correct by moving the formula to C7 and correcting the syntax. You could also add a pair of quotes after the last comma to suppress the 0 and have a blank cell result when it is not "10". If it still does not behave as expected, you might need to reverse the logical test: IF(TODAY()=A7, 10,"") applies 10 if date in A7 is today or a future date IF(TODAY()<=A7, 10,"") applies 10 if date in A7 is today or a past date From your written description it seems like your logical test is backwards. However if the 10 represents a late fee for example, then the formula is right and the description is misleading me. Roy "stevebriz" wrote: Hank wrote: I am trying to return a dollar amount due if the date in one cell is greater than or equal to today. I'm using this formula in an blank cell: IF(today() = A7 , C7=10,,) Can't get it to work. Using Excel 2003. Help please. Hank try this put this formula in C7 = IF(TODAY()=A7, 10,) |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date Math if then
Thanks stevbriz and Roy -- works perfect
Hank "stevebriz" wrote in message ups.com... Hank wrote: I am trying to return a dollar amount due if the date in one cell is greater than or equal to today. I'm using this formula in an blank cell: IF(today() = A7 , C7=10,,) Can't get it to work. Using Excel 2003. Help please. Hank try this put this formula in C7 = IF(TODAY()=A7, 10,) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Math | Excel Worksheet Functions | |||
| Date Math | Excel Discussion (Misc queries) | |||
| Date Math Problem | Excel Worksheet Functions | |||
| In Excel, I need a date math formula... | Excel Discussion (Misc queries) | |||
| Date-Math Calendarization Codes | Excel Programming | |||
![Hank[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
