LO Calc - Multiple operations, define Input

[lactea]

I have a complex calculation that returns result R from input A and B. A, B and R are shown in separate cells.

I would like to display the results of R as functions of A and B in a table (say A horizontal and B vertical).

This sounds to me like “multiple operations”. However, I cannot paste or link to the entire formula because it way to complex. Instead, I would like A and B to be changed and R being taken from the respective cell.

Is there a way to tell LO that both A and B have to be modified according to the table and the results being listed?

Maybe this is an entirely wrong approach to the issue. Any hint will be greatly appreciated.

edit: As I am not yet allowed to upload a file, please find an uploaded ods in my filelink: [deleted]

edit2:
I realize that I have not made myself understood properly, sorry for that. I have improved my example and hope you might get my issue better. Please find it in the link below. https://db.tt/jjgIc9kM

[Regina]

In H4 =MULTIPLE.OPERATIONS($D$3;$B$3;H$3;$C$3;$G4)

But there seems to be an error in LibreOffice 4.3, when you try to drag-fill the formula to the rest of the range. In Apache OpenOffice 4.1 Beta it works. And later on with copied formula it works in LibreOffice too.

The meaning of the parameters of MULTIPLE.OPERATIONS are

1. Cell containing the prototype of the formula
2. Cell, which is used as first variable in the prototype
3. Actual value of the first variable
4. Cell, which is used as second variable in the prototype
5. Actual value of the second variable

The many $ are necessary to keep the address parts while dragging.

Edit: Upload Ask 2014-03-16 example_improved_Mit_Formel.ods file containing MULTIPLE.OPERATIONS solution.

[lactea]

Thank you Regina for your efforts. As written, there is no prototype formula in my case, just a couple of cells that compute the results. Thus, there is nothing to be drag-filled. Your example does work in my case, however.
I will upload an improved example soon.

[Regina]

That works as well with Multiple.Operations. Have you tried it? I will upload your “example_improved.ods” with applied MULTIPLE.OPERATIONS.

[lactea]

I see it working for the first solution. Try changing A and/or B to see R, but no table updates. Even if you change A and B and then paste in the formula, it will still remain the initial result.

[Regina]

I do not understand you. The table in G3:K7 shows the results of all combinations of value A with value B. If you need other input value for Input A then those listed in H3:K3, then you have to change them in the range H3:K3. Perhaps calculating a two-dimensional table is not your problem? If you are only looking for a method to handle long formulas without using helper cells, then “named expressions” might be a tool for you.

[lactea]

Thank you again Regina. While handling with my various documents, I must have mixed something up. Your solution does work nicely. Glad you have helped my out.