Tadays date
 

In A4 though A186 there are dates, May 16, 2007 €“ Nov 14, 2007. In Column M a
dollar amount that I enter every day. At the end of the day if the value in M
is a negative number, I would like L3 to show by how much.

Tadays date
 

Kevin,

In L3, use a formula like

=IF(VLOOKUP(TODAY(),A4:M186,12,FALSE)<0, VLOOKUP(TODAY(),A4:M186,12,FALSE),"")

HTH,
Bernie
MS Excel MVP


"Kevin" wrote in message
...
In A4 though A186 there are dates, May 16, 2007 - Nov 14, 2007. In Column M a
dollar amount that I enter every day. At the end of the day if the value in M
is a negative number, I would like L3 to show by how much.

Tadays date
 

at the end of which day?
the last day entered? today? November 14th?

"Kevin" wrote:

In A4 though A186 there are dates, May 16, 2007 €“ Nov 14, 2007. In Column M a
dollar amount that I enter every day. At the end of the day if the value in M
is a negative number, I would like L3 to show by how much.

Todays date
 

Bernie

I after outing the formula in, nothikng apears in L3

BJ at the end of every day, todays date.

"bj" wrote:

at the end of which day?
the last day entered? today? November 14th?

"Kevin" wrote:

In A4 though A186 there are dates, May 16, 2007 €“ Nov 14, 2007. In Column M a
dollar amount that I enter every day. At the end of the day if the value in M
is a negative number, I would like L3 to show by how much.

Todays date
 

change the Bernie formula's from 12 to 13 should do the trick

"Kevin" wrote:

Bernie

I after outing the formula in, nothikng apears in L3

BJ at the end of every day, todays date.

"bj" wrote:

at the end of which day?
the last day entered? today? November 14th?

"Kevin" wrote:

In A4 though A186 there are dates, May 16, 2007 €“ Nov 14, 2007. In Column M a
dollar amount that I enter every day. At the end of the day if the value in M
is a negative number, I would like L3 to show by how much.

Todays date
 

if you want yesterday's value to show until you enter today's try

=IF(VLOOKUP(TODAY(),A4:M186,13,FALSE)="",
IF(VLOOKUP(TODAY()-1,A4:M186,13,FALSE)<0,
VLOOKUP(TODAY()-1,A4:M186,13,FALSE),"")
VLOOKUP(TODAY(),A4:M186,13,FALSE),""),IF(VLOOKUP(T ODAY(),A4:M186,13,FALSE)<0, VLOOKUP(TODAY(),A4:M186,13,FALSE),"")



"Kevin" wrote:

Bernie

I after outing the formula in, nothikng apears in L3

BJ at the end of every day, todays date.

"bj" wrote:

at the end of which day?
the last day entered? today? November 14th?

"Kevin" wrote:

In A4 though A186 there are dates, May 16, 2007 €“ Nov 14, 2007. In Column M a
dollar amount that I enter every day. At the end of the day if the value in M
is a negative number, I would like L3 to show by how much.