Extending formulas

  • Thread starter Thread starter SupportX
  • Start date Start date
S

SupportX

Subject: Extending formulas

Hi,

For my application that uses Excel for calculations. I need to be able to extend the forula base of Excell with complex scientifc functions. Is there a way to add new functions to the Excel function base?

Thanks

Spx.
 
MS has provided Visual Basic for Applications (VBA) to customize Excel
with new functions, commands, forms, menus, etc.

Tools|Macro|Visual Basic Editor
From the VBA editor
Insert Module
Then write your functions in VBA. Details of writting functions in VBA
is a very big topic,
http://www.fontstuff.com/vba/vbatut01.htm
may help you start, or look at books such as
Excel yyyy Power Programming with VBA by John Walkenbach
Writing Excel Macros with VBA by Steven Roman
You also can get newsgroup help at the
microsoft.public.excel.programming
newsgroup.

Jerry
 
My book "A Guide to MS Excel for Scientists & Engineers" will help you.
Sorry for apparent commercialism
 
SupportX wrote...
....
For my application that uses Excel for calculations. I need to be
able to extend the forula base of Excell with complex scientifc
functions. Is there a way to add new functions to the Excel
function base?
Click to expand...

Going in a different direction from the other respondents, why are
you using Excel for scientific calculations? If you're doing anything
with complex numbers, nontrivial tensors, or differntial equations,
Excel is far from the ideal tool. There are some free math packages
that are pretty useful - Octave and SciLab - and heavy-duty commercial
math packages like MatLab, Mathematica and MatCAD, and most of these
likely have already implemented what you need or provide so many of
the building blocks that writing exactly what you need would be simple.

I invite anyone who believes Excel can handle general math problems to
show how they'd calculate eigenvalues and eigenvectors in Excel. It can
be done, but it's UGLY.
 
Back
Top