cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Re-using formulas

SOLVED
corne_mo
Guest

Re-using formulas

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Re-using formulas

Something more like this?

View solution in original post

6 REPLIES 6

Re: Re-using formulas

Do you mean something like the attached?

Alan

Re: Re-using formulas

Some other simple possibilities?

Re: Re-using formulas

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?

Re: Re-using formulas

Something more like this?

View solution in original post

Re: Re-using formulas

Maybe I'm missing something, but what happened to the simple approach?

Mike

Re: Re-using formulas

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.

Announcements