Visibility of cells

Hi, welcome to the forum

You dont show column references, so assume Days Passed in in column B...

=IF(B2="","",yourformula)

Hello,

instead of pre-filling rows with formulas and then having to take steps to avoid applying calculations in rows with no data, you could have an Excel Table that automatically puts the formula in a new row.

In your screenshot, remove iterations 8 and above. Then click any cell in the table and click Insert > Table (or hit Ctrl-T). Now you can enter a new row of data below iteration 7. As soon as you enter something into a new row, any formula or formatting will be applied to the new row automatically. If we can assume that you will only add a new row when you have new data, you don't need a formula that prevents "wrong" values.

cheers, teylyn

Did you see my post above? We posted at the same time.

What do you mean by "I gave my formula a name"? It would help if you could share a sample Excel file, not a screenshot.

... and why did you do that? But you did not attach that version, did you?

There are no defined names in your attached file. I don't quite understand whether you may think that naming a range of cells is connected to your question. It is not.

The spreadsheet you attached does not have a single formula in the loan tables. I assume you would want to use formulas to calculate the values. Your question is about such formulas. I don't understand why you uploaded a file that does not show what you are asking about.

My suggestion:

On the "Car Loan" sheet, delete rows 15 and below.

Put the formulas back into the cells.

Select A7 to F14 and insert a table.
Select H7 to M14 and insert a table.

After that you can add new rows to each table, independently. Add a number for the increment, type in the values and the formulas will calculate the results.

cheers, teylyn