InfoPath Dev

 Hi

I'm new in InfopathDEV and I have a question. Ho to implement this formulas from Excel spreadsheet to Infopath.(its polish version Excel, but it doesn't matter - I can transtlate it).

 =ZAOKR(10-ILOCZYN(JEŻELI(D4="";"1";(10-D4)^F4);JEŻELI(D6="";"1";(10-D6)^F6);JEŻELI(D8="";"1";(10-D8)^F8);JEŻELI(D10="";"1";(10-D10)^F10);JEŻELI(D12="";"1";(10-D12)^F12))^(1/SUMA.JEŻELI(D4:D12;">0";F4:F12));2)

and

=ZAOKR(SUMA(F14*D14;F16*D16;F18*D18;F20*D20)/SUMA(F14;F16;F18;F20);2)
 

In Excel it's 2 forumulas and 10 variable. 

  I'm looking for solution of this trouble. I now - its possible use a button -> add rules -> add function but its very complicted or I can develop this in JScript or C#. Can we show what solutions is better ? And show example of ones of solutions. 

Regards

Arek

Hi:

Welcome to the forum! I'm not sure what the English translation is for your Excel functions, but the math looks more complex than what InfoPath may be able to do in a formula. Perhaps you could break the formula down some, provide some translation so that there is a better chance someone will be able to help?