How can I add a new formula to Excel formula list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need add a new formula developed by myself to the available list of Excel
formula. My Excell version is 2003
 
I'm assuming you mean 'Function'.

If your User Defined Function is in a currently open workbook OR in your
'Personal.xls' workbook OR in an add-in you've created, you will be able to
use it by selecting...
Insert / Function
Highlight either 'ALL' or 'User Defined' in the "Function Category" window
Scroll down until you see your UDF in the "Function Name" window.
Highlight the UDF and select 'OK'

HTH,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL - IF(IFERROR(VLOOKUP question 0
Array formula lock-up 1
Advanvnce formula and function 1
IF AND Nested Functions - Formula Not Working 0
using the =page! feature to transpose a row to column 0
formula similar to "countifs" function in excel 2007 2
Excel How to add numbers in same cell? 2
Paste Formula 4

Back
Top