Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Aug 2004
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    how can i get this formula (office XP)

    hi, attached is a file i get somewhere over the net and much interested in the formulas, perhaps they can improve my research result and a formula like =RegMovAvg($B$4:$B$48,C3) with Ctrl+Shift+Enter since it is an array formula, is it an user defined function (udf)? if it is, others with array formulas are also udf and i won't be able to ge the formulas calculation steps. i did the Evaluate Formula in the Formula Auditing toolbar to check the formulas nested behind and 'step in' isn't available, is this the way to check if i can use the formula in another worksheet? Thanks.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: how can i get this formula (office XP)

    The functions are probably in the addin file: "TANLY32.XLL" which you downloaded and installed.

    They might not be accessible to you. If you need to look at the formulas you will probably have to write the author of the addin as (most likely) it is protected.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •