Formula sheet with multiple inputs and outputs

  • I am trying to build a valuation sheet for our employees to value and rank the company overall or by business unit. I want the sheet to be variable, so that way they don't have to enter all values or can enter some and the sheet will pull default values for the output. I am trying to do this with formulas instead of vba to keep it end user simple. I can put most of it together, but when it comes to linking the top and bottom sections or having them reference each other, i start down the circular reference rabbit hole


    Valuation Exercise.xlsx

  • Hello,


    Attached is a guess of what you might be looking for ...;)


    Blue Cells are your input cells ...


    Hope this will help

    :)

    Files

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Thanks for taking a look. I guess i wasn't too clear that i was trying to have the input valuation and the per business unit valuation both be able to interact with each other as well. That is where i started running into the circular reference and couldn't see a way out of it, outside of using VBA to extract the known references and calculate accordingly.

  • Thanks for taking a look. I guess i wasn't too clear that i was trying to have the input valuation and the per business unit valuation both be able to interact with each other as well. That is where i started running into the circular reference and couldn't see a way out of it, outside of using VBA to extract the known references and calculate accordingly.


    Sorry ... but have to confirm you are not too clear about the interactions you want to build ...


    Could you attach the Test file with some written comments next the cells ... ?

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Thanks for your notes.


    Could you explain even further the detailed relationship between the cells ...?


    It seems to me you are after creating mutually exclusive cells...


    Is that right ...?

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)