Hi
I wonder if I could get some help please...
I've got a google sheet where I want to work out the maximum loan to value for each lead. Each lead is on it's own row. However the spreadsheet dynamically populates with a new row for each lead as the lead is generated so the sheet formula needs to take account of this.
I can't post any links yet as first time poster but if it helps the first lead row would be in row 2.
Here's the basic logic of the formula
formula = ((home value x 0.80) - outstanding mortgage) - debt amt
In spreadsheet home value is column M, outstanding mortgage is column N and debt amt is column L.
I'd be very grateful for any help, many thanks.
Graham
Bookmarks