If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I create a function in Excel?
I'm trying to build a function that takes few cells (including ranges), so that I can perform a calculation using those figures.
I'd like to use this function several times performing the same kind of calculation but using different cells and ranges. Ideally I can create a function similar to the ones already built in Excel (like PV, sum, etc...). How can I do that? Thanks a lot. |
#2
|
|||
|
|||
Can I create a function in Excel?
It would help if you were more specific about what type
of calculation(s) you are trying to attempt. You can learn more about creating UDF's by checking out previously posted examples in the google archinves: http://tinyurl.com/4ajhe HTH Jason Atlanta, GA -----Original Message----- I'm trying to build a function that takes few cells (including ranges), so that I can perform a calculation using those figures. I'd like to use this function several times performing the same kind of calculation but using different cells and ranges. Ideally I can create a function similar to the ones already built in Excel (like PV, sum, etc...). How can I do that? Thanks a lot. . |
#3
|
|||
|
|||
Can I create a function in Excel?
Thanks a lot Jason. I saw the answer in one of the postings that you referred me to. It was extremelly helpful. Good luck to you !!
"Jason Morin" wrote: It would help if you were more specific about what type of calculation(s) you are trying to attempt. You can learn more about creating UDF's by checking out previously posted examples in the google archinves: http://tinyurl.com/4ajhe HTH Jason Atlanta, GA -----Original Message----- I'm trying to build a function that takes few cells (including ranges), so that I can perform a calculation using those figures. I'd like to use this function several times performing the same kind of calculation but using different cells and ranges. Ideally I can create a function similar to the ones already built in Excel (like PV, sum, etc...). How can I do that? Thanks a lot. . |
#4
|
|||
|
|||
Can I create a function in Excel?
There are two ways to write your own functions for use in
Excel. You can use the "Define Name" facility that is normally used to define a name for a cell or a range. It will also accept a single line that calculates something using Excel formula functions. So you can write the single line formula, give it a name, then invoke it like a function. The more flexible way is to write a Visual Basic macro, which can be invoked on a worksheet IF it doesn't in any way try to change anything on the worksheet. Calculating a value is a good application for a macro function, since it returns a value. To write the macro, you can go into Tools-Macro-Record a Macro then start writng the function as a formula or series of formulas. The macro facility will generate a rudimentary macro for you, but you'll probably want to clean it up or add/remove things. You'll have to do some studying to write a macro, but the knowledge will be invaluable. -----Original Message----- I'm trying to build a function that takes few cells (including ranges), so that I can perform a calculation using those figures. I'd like to use this function several times performing the same kind of calculation but using different cells and ranges. Ideally I can create a function similar to the ones already built in Excel (like PV, sum, etc...). How can I do that? Thanks a lot. . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |
Word or excel function to create increasing numbers? | dmdivers | General Discussions | 0 | June 4th, 2004 01:41 PM |
IF Excel Function or Macro? | Bob | Worksheet Functions | 5 | April 8th, 2004 06:01 PM |
looking for Excel Function Reference book from 1992? | Matt | Worksheet Functions | 2 | October 29th, 2003 08:04 PM |