Growth- Trend and Lookup forumlae


#1

Hi. Can I add my own formulae to simulate growth, trend and lookup. Then inport a spreadsheet and it will work just fine?

Best regards

Keith


#2

Dear Keith,

How do you add your own formula?

1. You can add your own formula in VBA code of your designer spreadsheet. Then you import this file and call the following code at run time:

cell.Formula = “=MyFunction()”;

2. You can create an AddIn file and put your own formula in it, then you can call this:

cell.SetAddInFormula(“MyFormula.xla”, “=MyFunction()”);

The first approach is recommended.