Taylor series estimation program

[bockisch]

I am trying to write a program that estimates sin(x) for a school assignment. Here is what I have so far:

Please Login or Register  to view this content.

There is a compiler error around fact=((2*k)+1). It says there is an "expected end of function" and the 2 is highlighted. I don't know what this means or how to fix it.

[bockisch]

I have realized part of the problem. The function Factorial needs to be outside the main function. However, moving it only causes my program to return #VALUE. How can I fix this?

[Andy Pope]

If you use the debugger to step through the code line by line you would see the error is due to overflowing values.

The reason for the overflow is the variable being passed into the FACT function is being altered within the function.

Please Login or Register  to view this content.

If you use the ByVal keyword a copy of the value is passed in to the function.
Also from what I can see you only need to calculate the bottom variable once.

[bockisch]

Thanks, it compiles now. But the returned value for SinE(3,10) is 3 and that isn't right.

[bockisch]

In fact, it seems to be simply returning the number for x.

[Andy Pope]

If you change your singles to doubles the function should return 3.0000000020474

If you use the function on the worksheet you may need to increase the number of decimal points shown.

If not what answer did you expect from in the inputs 3 and 10?

[bockisch]

It should be an estimate of sin(3) in radians.

[shg]

You can calculate the factorial in-line as needed:

Please Login or Register  to view this content.

[MarvinP]

Your "bottom" variable needs to be moved into the For.. Next loop so it gives increasing numbers of factorials.

You will also need to change the "k" in your loop to "I" . You are incrementing I not k.