Add a ammount on a certain date.
Closed
ColinG
-
Dec 18, 2016 at 10:13 AM
yg_be Posts 23528 Registration date Sunday June 8, 2008 Status Contributor Last seen April 21, 2025 - Dec 18, 2016 at 10:55 AM
yg_be Posts 23528 Registration date Sunday June 8, 2008 Status Contributor Last seen April 21, 2025 - 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
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
Related:
- Add a ammount on a certain date.
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- How to add @ in laptop - Guide
- How to add songs to sound picker - Guide
- How to add someone on messenger with phone number - Guide
- Debian add printer - Guide
1 response
yg_be
Posts
23528
Registration date
Sunday June 8, 2008
Status
Contributor
Last seen
April 21, 2025
5
Dec 18, 2016 at 10:55 AM
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:
This would work, but this si probably not what you want:
=IF(A1<DATE(2016;12;22);A1+528.08;A1)
