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

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,)

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,)

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,)

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,)