For step functions stepfun mentioned by KenWIlliams and approxfun both work well. The following image shows how to create the y-values for this equation in Excel using the range of 1 to 10 for the x-values. So I am at work workin on this report and I need a function that will make Excel automatically insert the todays date in a cell lets say D90 when I fill the content of another cell for example C90 and the that will be.
It might be worth clarifying that this example is a step function a special class of piecewise functions.
By using these functions together we can extract the values of x1 y1 x2 and y2 we need for the interpolation. The first stage is to assign two adjacent columns for the values of x and f x. By using these functions together we can extract the values of x1 y1 x2 and y2 we need for the interpolation. So I am at work workin on this report and I need a function that will make Excel automatically insert the todays date in a cell lets say D90 when I fill the content of another cell for example C90 and the that will be.