Results 1 to 3 of 3
  1. #1
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    reversing formula result (Excel 2003)

    I have a list of 5 variables which are used to determine how many prospects must be targeted to get a certain number of customer leads. Each variable has a % assigned to it which limits the input to the next variable. Things like # of prospects, % of impressions, % responses, % leads, and finanlly # of customers.

    My goal is the have the user enter the # of customers they want to have as the final set and then 'back into' the other variables to arrive at the initial # of customers that need to be targeted to get this end number.

    I attached the spreadsheet which works for determining the end customer # but I need to go backwards and have that final calculation be the first (and only) input.

    // Thnx, Deb
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: reversing formula result (Excel 2003)

    See column F in attached version. Since the number of customers is derived from the number of prospects by repeated multiplication, the number of prospects is derived from the desired number of customers by repeated division.
    You could also use Tools | Goal Seek.
    Attached Files Attached Files

  3. #3
    5 Star Lounger jujuraf's Avatar
    Join Date
    Jun 2001
    Location
    San Jose, California, USA
    Posts
    1,061
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: reversing formula result (Excel 2003)

    Excellent. <img src=/S/bow.gif border=0 alt=bow width=15 height=15> I knew I had to divide it to go backwards but I messed up that simple task.

    Thank you,
    Deb

Posting Permissions

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