Add a ammount on a certain date.

Closed
Report
-
Posts
17757
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
December 5, 2021
-
Hi,
I`m trying to add my pension on a certain date each month to a spreadsheet cell.

IF((DATE(2016,12, 22) ;then_value(528.08);otherwise_value(0))

Can anybody tell me where i`m going wrong.

Thank`s

1 reply

Posts
17757
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
December 5, 2021
5
What do you want to do exactly?
This would work, but this si probably not what you want:
=IF(A1<DATE(2016;12;22);A1+528.08;A1)