Add a ammount on a certain date.

Question

Add a ammount on a certain date.

Closed

Report

ColinG - Dec 18, 2016 at 10:13 AM
yg_be

Posts: 17757
Registration date: Sunday June 8, 2008
Status: Contributor
Last seen: December 5, 2021

- 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

Add a ammount on a certain date.
How to add signature in thunderbird - How-To - Thunderbird
How to add contacts to messenger - How-To - Facebook
Add whatsapp stickers to telegram - Guide
Add settings to home screen iphone - How-To - iPhone
How to add new emoji to keyboard - How-To - Instant Messaging

1 reply

Ask a question

yg_be · Answer 1 · 2016-12-18T10:55:04-0500

Answer 1 / 1

yg_be

Posts: 17757
Registration date: Sunday June 8, 2008
Status: Contributor
Last seen: December 5, 2021

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)

Add a ammount on a certain date.

1 reply

Your reply

Subscribe To Our Newsletter!