Results 1 to 4 of 4

Thread: Create Custom Function

  1. #1
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007

    Create Custom Function



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,
    can we make our own or you may say i.e, custom function.

    suppose a formula i.e, =sum(A1:F1) and we define the name for the formula "xyz".

    My question is if we put the formula "xyz" in any workbook of different Excel file, than it calculates sum of the above range either absolute or relative reference.

    summery of question : How to record of custom formula

  2. #2
    You would need to put the UDF in an addin.

  3. #3
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Thanks for suggestion. But sir, I can not find in Excel Option---->Add-Ins--->Manage Excel Add-ins. I request you, please suggest how to install.

  4. #4
    You need to create a new workbook, add the UDF, save it as an addin, then get your people to install it http://office.microsoft.com/en-gb/ex...010342658.aspx

Posting Permissions

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