Results 1 to 5 of 5

"Control" Factor

Threaded View

athinaida "Control" Factor 05-04-2018, 05:39 AM
MrShorty Re: "Control" Factor 05-04-2018, 08:33 AM
athinaida Re: "Control" Factor 05-04-2018, 10:18 AM
MrShorty Re: "Control" Factor 05-04-2018, 10:56 AM
athinaida Re: "Control" Factor 05-08-2018, 10:45 AM
  1. #1
    Registered User
    Join Date
    10-02-2013
    Location
    London, UK
    MS-Off Ver
    Excel 365
    Posts
    42

    "Control" Factor

    Hello,

    I have the following case (Excel file attached):
    After a complex calculation (in the background), I get 2 final Results ( Cells F7 and F9)
    The value that we find in the cell A8 plays a major role in this background calculation (so, there is a correlation between A8 and the 2 final results, which I can't Show, because a lot of different worksheets and calculations are involved, but when the A8 changes, then the 2 results Change correspondingly)

    For the definition of the A8 value, I have a short analysis (really simple) in the line 2, where the value A2 plays an important role.

    What I would like to do is that I have a Kind of "control" formula that defines the value of the cell B2 (Factor 1), in order that I get as a result:
    - at least 20% as Result 1 AND
    - at least 10% as Result 2

    Is something like this possible?
    Attached Files Attached Files
    Last edited by athinaida; 05-04-2018 at 07:45 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 02-14-2012, 01:45 AM
  2. [SOLVED] How to make "common factor" formula ?
    By toyota58 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 04:05 PM
  3. [SOLVED] How to make "common factor" formula ?
    By toyota58 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 PM
  4. How to make "common factor" formula ?
    By Dave Peterson in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 09:05 AM
  5. How to make "common factor" formula ?
    By Dave Peterson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM
  6. [SOLVED] How to make "common factor" formula ?
    By toyota58 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 02:05 AM
  7. How to make "common factor" formula ?
    By toyota58 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  8. How to make "common factor" formula ?
    By toyota58 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-18-2005, 03:05 PM

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