Replacing the Analysis Toolpak Addin – Part 4

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:

Other ATP functions
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

One thought on “Replacing the Analysis Toolpak Addin – Part 4

Leave a Reply

Your email address will not be published. Required fields are marked *