This last part focusses on replacing some of the remaining functions of the Analysis Toolpak Addin (ATP). Reference to the other parts of this article series:
- Part 1: Mathematical functions
- Part 2: Date/Time functions
- Part 3: Numerical system conversion functions
- Part 4: Others
| ATP Function | Description | ATP Syntax | Replacement Formula | Array formula |
|---|---|---|---|---|
| DELTA | Test whether two values are equal | =DELTA(number1,number2) | =–(number1=number2) | No |
| ISEVEN | Returns TRUE if the number is even | =ISEVEN(Number) | =MOD(TRUNC(Number),2)=0 | No |
| ISODD | Returns TRUE if the number is odd | =ISODD(Number) | =MOD(TRUNC(Number),2)=1 | No |
So that is it. For the remaining ATP functions I currently have no replacement formula. If someone could provide corrections, additions I’m happy to amend the above tables accordingly.
Hope you find some of these formulas useful.
Frank
Is there any ‘C’ / ‘C++’ binary shift functions or and functions in excel. (i.e ‘C’ x