Thread: Any Excel gurus around?
View Single Post
Old 08-29-2016, 11:12 AM   #7
stearns
Dogbert Consultant
 
stearns's Avatar
16
 
Join Date: Oct 2008
First Name: Ben
Location: Park Hill
Posts: 5,381
Trading: (50)
RA
stearns is a name known to allstearns is a name known to allstearns is a name known to allstearns is a name known to allstearns is a name known to allstearns is a name known to all
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.
Forgot about ABS, that will make things smoother
__________________
"Ignoring all the racket of conventional reality" - Keller Williams
stearns is offline   Reply With Quote