Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Using Boolean logic instead of IF, AND, OR functions

  Asked By: Doan    Date: Dec 26    Category: MS Office    Views: 880
  

Although not strictly a question about VBA I thought someone on this
forum could give an answer to a simply query.

At the moment my workbooks make heavy use of the IF, AND, OR and NOT
functions, sometimes heavily nested, and I was wondering if a change
to Boolean logic gates would reduce the time it takes for the workbook
to recalculate. I seem to remember reading somewhere on the web that
this would be the case.

Share: 

 

3 Answers Found

 
Answer #1    Answered By: Shannon Johnson     Answered On: Dec 26

Go to http://xl-logic.com/ and  become a member. Select Downloads, then Formulas
and scroll down to Binary Switch Logic. This might be what your looking for.

 
Answer #2    Answered By: Adelgiese Fischer     Answered On: Dec 26

Just tried that link and  got the old 404.

 
Answer #3    Answered By: Oliver Jones     Answered On: Dec 26

Works OK for me.........................

 
Didn't find what you were looking for? Find more on Using Boolean logic instead of IF, AND, OR functions Or get search suggestion and latest updates.




Tagged: