Forum Discussion
Solved
Auto debit payment on or after set date of month
I need a formula that will input into a cell a negative number and keep it that way until a set date has arrived and then change it to a positive number and keep it positive thereafter. For instance...
- I would think you mean either $0.00 or the $9.99 fee (or whatever it is), not negative same amount switching to positive.
Here's a formula that refers to a date--I'd put the dates the payments are due in their own column (A4 in this example) next to the Netflix entries.
=IF(A4>TODAY(),0,9.99)
This keeps the value at zero until the date is passed the auto-payment date.
I would think you mean either $0.00 or the $9.99 fee (or whatever it is), not negative same amount switching to positive.
Here's a formula that refers to a date--I'd put the dates the payments are due in their own column (A4 in this example) next to the Netflix entries.
=IF(A4>TODAY(),0,9.99)
This keeps the value at zero until the date is passed the auto-payment date.
Here's a formula that refers to a date--I'd put the dates the payments are due in their own column (A4 in this example) next to the Netflix entries.
=IF(A4>TODAY(),0,9.99)
This keeps the value at zero until the date is passed the auto-payment date.
I didn' think to give the due dates their own column. I'll give this a try and see how well it works for my needs. Thank you!