function stumped

C

Curt

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

Gary''s Student

Say we want to add 123 each time we pass the 15th of the month.
Let's us a small table, A1 thru A12
In A1 enter:
=IF(TODAY()>DATE(2009,ROW(),15),123,0) and copy down thru A12
Today we see:
123
123
0
0
0
0
0
0
0
0
0
0
we get 123 for January and February, but not yet March because today is
before the 15th.

In anoth cell enter:
=SUM(A1:A12) This is the value you need.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding dates in a IF Statement 2
add on date specfic 1
If Formula and Dates 4
Merging from an Excel file with graphics 1
TODAY() issues 6
Getting the Sum from months 6
if function error 3
Excel PMT Function Help 2

Top