• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formula to reference value inside of a shape

I have values entered in the shapes labeled Buy Stop, Gain and Loss.

In the shape called Sell Limit, I want to enter a formula to add the value in Buy Stop to the value in Gain.
In the shape called Sell Stop, I want to enter a formula to subtract the value in Loss from the value in Buy Stop.

I know you can select a shape, then link to a cell with a value, to display that value inside of the shape, but that's not what I want to do. In short, in one shape, I want to enter a formula to reference the value inside of another shape. Is there a way to do this?
 

Attachments

  • Chandoo.org - Formulas Referencing Shape Values.xlsx
    13.2 KB · Views: 3
Formula's inside shapes can only reference cell's directly
eg: =Sheet1!A1

So you have to do all your math on the worksheet and reference the correct cells there
Then link your shapes to the correct cells
 
Back
Top