View Single Post
Old 08-29-2016, 11:20 AM   #8
pnoon
YNWA
 
pnoon's Avatar
16
 
Join Date: Oct 2008
First Name: Peter
Location: San Diego
Posts: 29,919
Trading: (20)
RA
pnoon has disabled reputation
Default Re: Any Excel gurus around?

Quote:
Originally Posted by markem View Post
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.
__________________
Be more concerned with your character than your reputation, because your character is what you really are, while your reputation is merely what others think you are.
-John Wooden
pnoon is offline   Reply With Quote