creating a custom formula in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1959070%22%20slang%3D%22en-US%22%3Ecreating%20a%20custom%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1959070%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%2C%3C%2FP%3E%3CP%3EI%20want%20to%20evaluate%20a%20polynomial%20function%20in%20Excel.%20This%20function%20in%20two%20variables%20has%20been%20inserted%20into%20a%20cell%20where%20I%20want%20the%20answer.%3CBR%20%2F%3E%3DA8%2B(A9*F5)%2B(A10*G5)%2B(A11*F5%5E2)%2B(A12*G5%5E2)%2B(A13*F5*G5)%3C%2FP%3E%3CP%3ENow%20I%20have%20to%20declare%20this%20as%20a%20formula%20in%20order%20for%20it%20to%20work%20properly.%20How%20can%20I%20do%20this%20easily%20without%20going%20into%20Visual%20Basic%3F%26nbsp%3B%20Possible%3F%20I%20want%20this%20to%20be%20as%20simple%20as%20possible.%3C%2FP%3E%3CP%3EI%20have%20made%20a%20template%2C%20documented%20the%20optimization%20steps%20with%20the%20exception%20of%20how%20to%20input%20the%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20getting%20an%20error%20message%20-objective%20cell%20contents%20must%20be%20a%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%26nbsp%3B%20MM%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1959070%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1959146%22%20slang%3D%22en-US%22%3ERe%3A%20creating%20a%20custom%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1959146%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F821111%22%20target%3D%22_blank%22%3E%40mmarion%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETo%20make%20it%20as%20function%20without%20VBA%20that's%20only%20with%20LAMBDA%20which%20is%20only%20coming%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel-blog%2Fannouncing-lambda-turn-excel-formulas-into-custom-functions%2Fba-p%2F1925546%22%20target%3D%22_blank%22%3EAnnouncing%20LAMBDA%20(microsoft.com)%3C%2FA%3E%26nbsp%3B.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1959419%22%20slang%3D%22en-US%22%3ERe%3A%20creating%20a%20custom%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1959419%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%26nbsp%3Bfor%20your%20reply.%20How%20can%20I%20do%20it%20without%20lambda%20then%3F%20I%20remember%20writing%20some%20code%20-%20just%20a%20few%20lines.%20How%20to%20do%3F%3CBR%20%2F%3E%3CBR%20%2F%3ESincerely%2C%3CBR%20%2F%3EMM%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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.