Results 1 to 2 of 2
2004-09-17, 14:34 #1
- Join Date
- Aug 2004
- 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.
2004-09-17, 14:53 #2
- Join Date
- Jul 2002
- Pittsburgh, Pennsylvania, USA
- 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.