Skip to main content
C
corne_mo1-Visitor
1-Visitor
July 17, 2012
Solved

Re-using formulas

  • July 17, 2012
  • 3 replies
  • 3227 views

I have to do some calculations within one sheet which I have to repeat a couple of times.

For example:

Input:

A

Calculations:

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.

Best answer by wayne

Something more like this?

3 replies

A
AlanStevens19-Tanzanite
19-Tanzanite
July 17, 2012

Do you mean something like the attached?

Alan

W
wayne12-Amethyst
12-Amethyst
July 25, 2012

Some other simple possibilities?

C
corne_mo1-VisitorAuthor
1-Visitor
September 12, 2012

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?

W
wayne12-AmethystAnswer
12-Amethyst
September 12, 2012

Something more like this?

C
corne_mo1-VisitorAuthor
1-Visitor
September 13, 2012

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

becomes:

P(A):=A+1 Q(A):=P(A)-2 R(A):=Q(A)^2

thanks.

Terms & ConditionsAccessibility statement