Any Excel gurus around?

[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

[markem]

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.

[stearns]

Originally Posted by markem

This line works for me:

=IF((ABS(B1-A1)<1.5), "TRUE", "FALSE")

the column information is spreadsheet specific, but you get the idea.

Forgot about ABS, that will make things smoother

[pnoon]

Originally Posted by markem

This line works for me:

=IF((ABS(B1-A1)<1.5), "TRUE", "FALSE")

the column information is spreadsheet specific, but you get the idea.

I'm only guessing here but I would assum the boundary condition of 1.5 would be a positive result. If so, reversing the sign and results will do the trick

=IF((ABS(B1-A1)>1.5), "FALSE", "TRUE")

The literals could also be changed to PASS/FAIL, YES/NO, etc.