How can i compute i formula in Excel for multiple values of one parameter which differ by only 1?

Question

I have a Gaussian formula for a line profile and within the formula is a parameter which varies stepwise in the same fashion from its smallest value right through to its largest value. Instead of writing out all the values in adjacent cells, is there a way i can use a minimum amount of cells and yet still generate a value of the formula in each case for each value of this parameter? Is there a ranging or iterative ability in Excel?

Answer 1

Yes there are. At the simplest level you can put the stepwise values on a different row of cells then input their value list directly to those cells. The Gaussian formula row can link to those cells.

At the next level you can write some VBA code to access any cell to input/output any value and program mostly any function.

At the expert's level you can use another package such as Matlab, C, or FORTRAN to model your problem and make a DLL which Excel VBA code can call and do anything you want.

Excel has its Gaussian set of functions. It also has the erf() function which can do integration at higher z-scores for extremely low error probabilities as well as doing cumulative integrations such as cdf, or ccdf.