Forum Discussion
Excel
Im doing an mortgage payoff amortizatuon spread sheet and i have a cell called payoff which is suppose to tell me when my balance is paid off. Right now its showing me what row my balance is at 0 but ...
This is the formular that im using but it gives me the row number not the month number
=MATCH(0,BalanceRange,0)-1
=MATCH(0,BalanceRange,0)-1