Re: How to implement formulas from Excel to Infopath

Hilary Stoupa — Fri, 19 Feb 2010 00:01:58 GMT

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?

How to implement formulas from Excel to Infopath

arekk82 — Tue, 16 Feb 2010 15:21:39 GMT

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

General

Re: How to implement formulas from Excel to Infopath

How to implement formulas from Excel to Infopath