I have to do some calculations within one sheet which I have to repeat a couple of times.
B = A + 1
C = A * 3
D = B / C
And then I want to publish both B, C and D.
My (printable left side) should look like:
A = x B = x C = x D = x
The formulas need to be located somewhere on the right side page.
But I want to be able to re-use the formulas so my left page will look like:
A.1 = x B.1 = x C.1 = x D.1 = x
A.2 = x B.2 = x C.2 = x D.2 = x
and I don't want to have to copy all the formulas all the time.
I know I can work with matrices, but that's not what I want. I really want to address a function and return the results from there.
Is this possible? And if so, how do I do this?
Thanks in advance for your replies.
Solved! Go to Solution.
Thanks both for your suggestions.
My problem is however that this doesn't really work, as not all my results are directly based on 1 input parameter.
What I have now is:
P(A):=A+1 Q(P):= P-2 R(Q):=Q^2
A.1:= 5 P(A.1) = 6 Q(P(A.1)) = 4 R(Q(P(A.1))) = 16
As you can see this is horrible to work with. Also my formulas are too difficult to read when I combine them and base all results on 1 variable like this:
P(A):= A+1 Q(A):= (A+1)-2 R(A):=((A+1)-2)^2
A.1:=5 P(A.1) = 6 Q(A.1) = 4 R(A.1) = 16
So what I want to do is really like at the index or something else to pass info to other formulas. I know this sounds like array calculations, but is said, that is not exactly what I want. Because I want:
P.x:=A.x+1 Q.x:=P.x-2 R.x:=Q.x^2
A.1:= 5 P.1=6 Q.1=4 R.1=16
A.2:=6 P.2=7 Q.2=5 R.2=25
And that without having to re-write the formulas over and over again.
Is this possible?
Thanks for the extra examples.
@ Mike Armstrong: I don't want to work with matrices as my output format of the sheet should look plain text.
@ Wayne Reid: The first lines are what I need.
|P(A):=A+1||Q(P):= P-2 R(Q):=Q^2|
P(A):=A+1 Q(A):=P(A)-2 R(A):=Q(A)^2