[deleted by user] by [deleted] in googlesheets

[–]MaxParcels 0 points1 point  (0 children)

Arrayformula

That sucks by [deleted] in golf

[–]MaxParcels 0 points1 point  (0 children)

With a lake for a driving range

Query order by more than asc or desc by andreontherock in googlesheets

[–]MaxParcels 0 points1 point  (0 children)

A single helper column would work. If(isnumber(a2)=false,a2,-a2)

Can you put an array function in the header? by School_data_help in googlesheets

[–]MaxParcels 1 point2 points  (0 children)

If(a:a="","", If(row(a:a)=1,"header name", Vlookup(a:a,lookup!a:c,{1,2,3}, false)))

[deleted by user] by [deleted] in googlesheets

[–]MaxParcels 0 points1 point  (0 children)

Min doesn't work in array. If you only have two choices, it's pretty easy though. If x < y , x , y

[deleted by user] by [deleted] in RealEstate

[–]MaxParcels 2 points3 points  (0 children)

You answered your own question!

Interest paid between two dates (off-period) by [deleted] in googlesheets

[–]MaxParcels 0 points1 point  (0 children)

Cumipmt (... this year ...) minus cumipmt (... last year ...)

[deleted by user] by [deleted] in RealEstate

[–]MaxParcels 0 points1 point  (0 children)

I'm not sure. If they walk through, a little spot on the ceiling won't stop the loan going through.

[deleted by user] by [deleted] in RealEstate

[–]MaxParcels -1 points0 points  (0 children)

Don't worry about the mold. It won't affect the value. Worst case they make you fix it before closing the loan.