Cigar Asylum Cigar Forum  

Go Back   Cigar Asylum Cigar Forum > Non Cigar Specialty Forums > Misc > Networking

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old 08-29-2016, 11:57 AM   #12
benedic08
Bob's great grandson
 
benedic08's Avatar
3
 
Join Date: May 2010
First Name: Benedic
Location: Hot and Wet Manila
Posts: 525
Trading: (8)
Bolivar
benedic08 has a spectacular aura aboutbenedic08 has a spectacular aura about
Default 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.
benedic08 is offline   Reply With Quote
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -6. The time now is 11:36 PM.


Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
All content is copyrighted jointly by Cigar Asylum and the content provider.