Ask Your Question

How can I display the result of a formula in another cell?

asked 2020-01-11 16:19:14 +0100

Abert gravatar image

I have this formula in F28 =IF(B28>0,F27-E28+D28) It works fine displaying the result in F28 and increments with each row. I would like to add to the formula so it also displays that result in another cell and on another sheet. Any ideas?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2020-01-12 09:07:28 +0100

If I'm understanding your question, go to whatever cell in any sheet you want to enter the results in, enter =, then go to your "F28" an hit "Enter".

edit flag offensive delete link more

answered 2020-01-11 16:35:03 +0100

Opaque gravatar image


use =IF($B$28>0,$F$27-$E$28+$D$28 (absolute addressing - see also LibreOffice Help - Addresses and References, Absolute and Relative) in another cell

Hope that helps.

If the answer helped you to solve your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more


Thanks for your reply, this formula starts at F7 and increments down the column (currently F28) and its the last entry in column F that I need to send to another location. My thoughts were adding a line to the formula to copy the result to another cell only if it is the last entry in F. Is this possible?

Abert gravatar imageAbert ( 2020-01-11 17:52:21 +0100 )edit

I don't understand - Formulas don't copy anything. Formulas calculate values based on other cells. So your question make no sense at all. Thus, what you call another cell must contain its own formula, to calculate a value. And that's what my answer is about: Cell formulas containing absolute addressing can be copied to other cells without columns and rows to be translated. If you just need the content (i.e. the result of the formula) of F28 in another cell, write =F28 into another cell (whatever it is).

Opaque gravatar imageOpaque ( 2020-01-11 19:02:16 +0100 )edit

Many thanks for your help and sorry for not making my self clear. The result of the formula in column F will not always be in the same row and I wanted to automatically have it show as F7 on subsequent sheets. I have now created a hidden sub total in F100 which I have referenced as you advise to the following sheets. Works a treat. Thanks again

Abert gravatar imageAbert ( 2020-01-12 17:09:50 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-01-11 16:19:14 +0100

Seen: 44 times

Last updated: Jan 12