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.