Ask Your Question
0

Reference a formula instead of a value?

asked 2017-03-09 17:15:33 +0100

medicengonzo gravatar image

updated 2017-03-09 17:19:13 +0100

Is it possible to refrence a formula in a cell instead of the value result of said cell?

For example:

I have the formula =sum(A1:A5) in the cell A1. In cell B1 i would like to reference the formula in A1 so instead of getting the result of the sum I get the string =sum(A1:B5)

Is this possible in LibreCalc?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-03-09 17:33:46 +0100

Guess what? This will do: =FORMULA(A1)

edit flag offensive delete link more

Comments

Nice! Is there any way i can get it without the = sign? I mean sum(A1:A5). I am trying to use it in another formula.

medicengonzo gravatar imagemedicengonzo ( 2017-03-09 18:27:32 +0100 )edit

=MID(FORMULA(A1);2;65535)

Mike Kaganski gravatar imageMike Kaganski ( 2017-03-09 18:42:02 +0100 )edit

Exactly what I needed! Thanks

medicengonzo gravatar imagemedicengonzo ( 2017-03-09 18:53:15 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-03-09 17:15:33 +0100

Seen: 55 times

Last updated: Mar 09 '17