Tadays date

K

Kevin

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.
 
B

Bernie Deitrick

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
 
K

Kevin

Bernie

I after outing the formula in, nothikng apears in L3

BJ at the end of every day, todays date.
 
B

bj

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(TODAY(),A4:M186,13,FALSE)<0, VLOOKUP(TODAY(),A4:M186,13,FALSE),"")
 
Top