Not sure what you want but maybe return "" if L4 not equal to 2?

=IF(L4=2,123,"")

To add 123 into another cell, the other cell would also have a similar
formula.


Gord Dibben MS Excel MVP

On Wed, 4 Mar 2009 10:58:10 -0800, Curt
wrote:

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.