View Single Post
Old 08-29-2016, 11:58 AM   #13
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 Steve View Post

Quote:
Originally Posted by benedic08 View Post
You can set aside a cell and put in 1.5 in that cell. For example we use cell X1 and have 1.5 in there. You can edit Peter's formula =IF((ABS(B1-A1)>X1), "FALSE", "TRUE"). To make adjustments, you can quickly change X1 to 1 or .5 and all the formulas pointing to it will adjust accordingly.
__________________
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