Quote:
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.