Search: | |||||

| ||||

Home » Forum » MS Office | RSS Feeds |

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.

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.

Just tried that link and got the old 404.

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.

Related Topics:

- rewriting a function for metric instead of imperial
- About using UTF-8 charset in JSP pages in Web logic
- Using QueryTable instead of OpenText with a file that has fixed width
- Can Any one help me writing logic for the given formula
- Please Help on IF AND OR logic
- Wait function and Invisible function
- Design Logic
- Logic error
- BEA Web Logic
- J2EE logic test solution - JTracker
- Wait function and Invisible function
- Array Logic
- help needed for logic building
- how to make alphabets uppercase without using function
- Column Headings using getColumnName function
- help requested for using excel's built-in function in coding
- smaller number possible instead of the maximum
- Java client instead JavaScript and AJAX, Flash
- RAW and LONG RAW instead of CLOB and BLOB in TimesTen
- How can I call the function TotalPrice within another function?
- user defined functions
- Linest Function
- help on functions
- Problems with XL's 'MATCH' function
- Excel won't calculate my function