[Solved] Showing both formula and result

[Stary1993]

Hi Everyone,

I am having a formula in Cell D9 and I want to put the result of this formula in Cell G9. Please note that I want formula showing in cell D9, and cell G9 should contain the result of formula written in D9. How do i do this?

Please help urgently.

Thanks
Adel

[robleyd]

The result of a formula can only be shown in the same cell as the formula. Imagine trying to maintain a spreadsheet where all the formulae were scattered anywhere other than where the results were displayed - nightmare!

However, you can use the FORMULA() function to display the text of a formula from another cell; put the formula in G9 where the result will appear, and in D9 put

Code: Select all

=Formula(G9)

[Stary1993]

That's it! Thanks a lot!