D
DB62225
I am wondering if anyone can help me figure out how to finish m
spreadsheet?
I am doing a Budget spreadsheet. I am trying to track the irregula
payments we make to our credit cards. I want to design a spreadshee
that will show on one page all of the payments I have made to th
credit card, listing the current balance beside the date they wer
made. On the other sheet or the same sheet no matter I want to have th
ability to input the amount of this months payment and have the shee
automatically subtract it from the total owing and place the amount o
the list of past payments.
I have most of it figured out except for one critical part. I am usin
the functions "IF" along with "DATEDIF" to determine whether th
inputed payment is current or not, which works fine except the "TRUE
or "FALSE" conditions change all of the boxes in the list of pas
payments and not just the current one.
I don't know if I made my problem clear or not, but I would welcome an
help figuring this out?!?!?!
spreadsheet?
I am doing a Budget spreadsheet. I am trying to track the irregula
payments we make to our credit cards. I want to design a spreadshee
that will show on one page all of the payments I have made to th
credit card, listing the current balance beside the date they wer
made. On the other sheet or the same sheet no matter I want to have th
ability to input the amount of this months payment and have the shee
automatically subtract it from the total owing and place the amount o
the list of past payments.
I have most of it figured out except for one critical part. I am usin
the functions "IF" along with "DATEDIF" to determine whether th
inputed payment is current or not, which works fine except the "TRUE
or "FALSE" conditions change all of the boxes in the list of pas
payments and not just the current one.
I don't know if I made my problem clear or not, but I would welcome an
help figuring this out?!?!?!