Oct 06 2021 05:36 AM
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, my Netflix payment is auto-debited from my banking account on the 15th of each month. Instead of entering that payment manually, a formula that would auto-enter that payment (keeping it negative until it is paid, keeping it positive after being paid) would be nice to have. I have a simple Excel 365 budget sheet (divided into 2 six month (Jan - Jun & Jul - Dec) sections) to track my monthly household payments. Thank you in advance!
Oct 06 2021 05:45 AM
SolutionOct 06 2021 05:53 AM
Oct 06 2021 07:23 AM
Oct 06 2021 05:45 AM
Solution