creating a custom formula in excel

Copper Contributor

Greetings,

I want to evaluate a polynomial function in Excel. This function in two variables has been inserted into a cell where I want the answer.
=A8+(A9*F5)+(A10*G5)+(A11*F5^2)+(A12*G5^2)+(A13*F5*G5)

Now I have to declare this as a formula in order for it to work properly. How can I do this easily without going into Visual Basic?  Possible? I want this to be as simple as possible.

I have made a template, documented the optimization steps with the exception of how to input the formula.

 

I am getting an error message -objective cell contents must be a formula.

 

Thank you.  MM

3 Replies

@mmarion 

To make it as function without VBA that's only with LAMBDA which is only coming Announcing LAMBDA (microsoft.com) . 

@Sergei Baklan 

 

Thank you for your reply. How can I do it without lambda then? I remember writing some code - just a few lines. How to do?

Sincerely,
MM

@mmarion 

If you mean VBA that's not my territory, perhaps someone else could help.