Add a ammount on a certain date.

Closed
ColinG - Dec 18, 2016 at 10:13 AM
yg_be Posts 23408 Registration date Sunday June 8, 2008 Status Contributor Last seen December 26, 2024 - Dec 18, 2016 at 10:55 AM
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 23408 Registration date Sunday June 8, 2008 Status Contributor Last seen December 26, 2024 5
Dec 18, 2016 at 10:55 AM
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)
0