View Single Post
Old 08-29-2016, 11:09 AM   #6
markem
Bunion
 
markem's Avatar
16
 
Join Date: Oct 2008
First Name: Mark
Location: Second Star on the Right
Posts: 22,462
Trading: (47)
HUpmann
markem has disabled reputation
Default Re: Any Excel gurus around?

Quote:
Originally Posted by stearns View Post
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.
__________________
I refuse to belong to any organization that would have me as a member.
~ Groucho Marx
markem is offline   Reply With Quote