Quote:
Originally Posted by stearns
Happy to help as well, I spend most of most of my days in excel. I think what Mark is eluding to is all you need, something like a =IF(x-y<1.5,YES,NO) where x is the cell with the actual distance and y is the cell with the estimated distance. You can do basic formulas like this in a gsheet if you want to be able to use it on the run through google drive. Let me know if I can be of assistance  |
This line works for me:
=IF((ABS(B1-A1)<1.5), "TRUE", "FALSE")
the column information is spreadsheet specific, but you get the idea.