View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default function stumped

Google Groups:

http://tinyurl.com/d92fed

--
Biff
Microsoft Excel MVP


"Curt" wrote in message
...
Want to have on a given date add an amount to a cell. When I use date to
get
amount. After date changes amount in given cell goes away.
=IF((L4=2),123) puts 123 into m4 only on day then its gone.
L4 is day of date
Final is to have 123 added into another cell on date each month this is a
monthly expendure.