Results 1 to 3 of 3

KPI goal seeking problem

Threaded View

  1. #1
    Valued Forum Contributor Neil_'s Avatar
    Join Date
    04-19-2013
    Location
    Yorkshire
    MS-Off Ver
    Office 365 Enterprise E3 2013 / 2016
    Posts
    479

    KPI goal seeking problem

    Hi,
    I need help with a formula in the attached workbook. In Cell C3 I need a formula which will make Cell C4 equal to cell a4


    Book1.xlsx

    Values
    
    budget	           actual	Correction
    3113	           2629	        2629
    1503	           1331	
    0.325606586	   0.336111111   0
    
    
    formulas
    
    budget	           actual	Correction
    3113	           2629	        2629
    1503	           1331	        =?
    =A3/(A2+A3)	   =B3/(B2+B3)	=C3/(C2+C3)
    The formula next to the question mark must force the cell below it to equal 0.325606586
    Last edited by Neil_; 05-28-2014 at 11:30 AM. Reason: forum rules
    Frob first, tweak later

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 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