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

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 close merge delete

Sort by » oldest newest most voted

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".

more

Hello,

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.

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?

( 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).

( 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

( 2020-01-12 17:09:50 +0100 )edit