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.

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.
.

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.
.

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.
.