J
JNW
I am doing some mortgage calculations. Based on any number of variables and
calculations the final payoff date can vary. I have a spreadsheet with the
date (in mmm-yy form) in one column and another with the remaining amount on
the mortgage (which is a negative amount until payed off then turns
positive). What I need is some way funtion to return in cell a1 the date at
which the value turns positive.
Thank you
calculations the final payoff date can vary. I have a spreadsheet with the
date (in mmm-yy form) in one column and another with the remaining amount on
the mortgage (which is a negative amount until payed off then turns
positive). What I need is some way funtion to return in cell a1 the date at
which the value turns positive.
Thank you