Cigar Asylum Cigar Forum - View Single Post

benedic08 · 08-29-2016, 11:57 AM

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.

08-29-2016, 11:57 AM	#12
benedic08 Bob's great grandson Join Date: May 2010 First Name: Benedic Location: Hot and Wet Manila Posts: 525 Trading: (8)	Re: Any Excel gurus around? 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.