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.