Cigar Asylum Cigar Forum  

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

Reply
 
Thread Tools Display Modes
Old 08-29-2016, 11:57 AM   #1
benedic08
Bob's great grandson
 
benedic08's Avatar
3
 
Join Date: May 2010
First Name: Benedic
Location: Hot and Wet Manila
Posts: 530
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
Reply

Thread Tools
Display Modes

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 06:30 PM.


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