+ Reply to Thread
Results 1 to 4 of 4

VPA calculator button

  1. #1
    Registered User
    Join Date
    07-19-2019
    Location
    Belfast
    MS-Off Ver
    2016
    Posts
    2

    VPA calculator button

    I am trying to link 3 cells together so that when one cell is changed, the other two cells change accordingly.Capture.PNG
    In the attached screengrab, are the three cells that I am trying to link. Currently, the only cell with formula, is "Females Placed", which is calculated by: "Bird area (m2)"*"Stocking Density (birds / m2)". Is there a way that I can link all three cells, so that I can change any two values at a time, and the third value is automatically calculated, i.e. when I change "Females Placed" and "Bird area (m2)", then a value for "Stocking Density (birds / m2)" is automatically calculated, or if I change "Stocking Density (birds / m2)" & "Females Placed", then "Bird area (m2)" is calculated. I initally thought of inserting three individual VPA calculator buttons?

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    2013, Office 365 ProPlus
    Posts
    4,908

    Re: VPA calculator button

    Hmm, so you are wanting to adjust 2 values as any 1 of 3 cells get changed?

    But "Stocking Density" is dependent on both "Bird area" and "Females placed"...

    There will be multiple condition which will satisfy "Stocking Density". And can not be solved without other constraints.

    Why not just set up formula for Stocking Density and change other two values?
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

  3. #3
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    2016
    Posts
    1,247
    With Helper Fields for the inputs and using conditional formatting It is not that difficult to do.

    Please have Look at the attachment. When you fill to Field The Dirt wil Grey out And the result is calculated in the Field Next to it.
    This Is A Basic Solution. With VBA it cloud be possible to insert formula or manual input in the same cell
    Attached Files Attached Files

  4. #4
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    2013, Office 365 ProPlus
    Posts
    4,908

    Re: VPA calculator button

    Oh I misread. Change 2 value to calculate 3rd value.

    That makes more sense

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1