Dec 05 2020 08:04 AM
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
Dec 05 2020 09:03 AM
To make it as function without VBA that's only with LAMBDA which is only coming Announcing LAMBDA (microsoft.com) .
Dec 05 2020 12:01 PM
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
Dec 05 2020 01:29 PM
If you mean VBA that's not my territory, perhaps someone else could help.