Ask Your Question
0

How to compute a calculation written in another cell (without the equals sign) [closed]

asked 2013-10-05 14:21:39 +0100

remjg gravatar image

In the minimal example below, I want to automatically compute in the cells B2 and B3 the calculations written in the cells A2 and A3:

Minimal Example

How would you do it without writing again the calculation with an equals sign before ?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-10 16:29:18.136989

1 Answer

Sort by » oldest newest most voted
1

answered 2013-10-05 15:07:32 +0100

m.a.riosv gravatar image

I know no way, but what you can do is enter the formula in result and use the FORMULA() function to show it in Calculation.

A2: =FORMULA(B2)
B2: =2*3

if you don't like the equal show in the formula:
A2: =MID(FORMULA(B2);2;999)

And maybe this extension can help:
http://extensions.libreoffice.org/extension-center/display-formula-and-value-simultaneously

edit flag offensive delete link more

Comments

That is perfect! Thank you very much!

remjg gravatar imageremjg ( 2013-10-05 15:52:24 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2013-10-05 14:21:39 +0100

Seen: 57 times

Last updated: Oct 05 '13