Macro solves the mathematical expression

Hi there,

Try using the following code:

Please Login or Register  to view this content.

You can change the values of the various constants to suit your own requirements.

You'll need to save the workbook as an "Excel Macro-Enabled Workbook" with an extension of .xlsm, because the workbook you posted (extension .xlsx) cannot store VBA Code (macros)

Hope this helps - please let me know how you get on.

Regards,

Greg M

How about just a formula?

Row\Col	A	B	C	D
2	x	y	expression
3	-1.23	2.00	-0.3571928	C3: =SUM(COS((A3 + {-6,-5,-4,-3,-2,-1,0,1,2,3,4,5,6}) / B3))