2 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

leaving 2 columns blank unless another is filled

So follow up to my early question:

I would like to move the new balance to the "Total left" column after a payment is made(I will manually do that).

I would like the "total after payment" and "months left" columns to be blank unless I mark the column "payment made" as completed.

So for instance: C is a column for "payments made"

B is the payment I make(with processing fees or whatnot)

D is "total" meaning how much is due right now

E is the minimum payment due

G is "total after payment"

H is "est months left"

So B is how much is coming out of my account (budgeting income and whatnot)

Once it's paid I mark C

D stays static as how much I still owe (mortgage, loans, etc.)

E is how much the minimum payment is required

F is interest rate

G is how much is left after the payment is made (from E) [=FV(F7/12, 1, E7, -D7)]

H is how many months are left [=NPER(F7/12, E7,-D7)]

so is there a way to make G and H blank until I mark C?

submitted by /u/tossedAF
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#natural language processing for spreadsheets
#Excel alternatives for data analysis
#generative AI for data analysis
#rows.com
#Excel compatibility
#large dataset processing
#financial modeling with spreadsheets
#natural language processing
#Excel alternatives
#payments made
#total left
#minimum payment
#total after payment
#months left
#mortgage
#due amount
#loans
#processing fees
#interest rate
#NPER function