Add a ammount on a certain date.

Closed
ColinG - 18 Dec 2016 à 10:13
yg_be Posts 23437 Registration date Sunday 8 June 2008 Status Contributor Last seen 6 June 2025 - 18 Dec 2016 à 10:55
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 response

yg_be Posts 23437 Registration date Sunday 8 June 2008 Status Contributor Last seen 6 June 2025 5
18 Dec 2016 à 10:55
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)