+ Reply to Thread
Results 1 to 2 of 2

How to make a referenced cell become a certain value based on a desired final output?

  1. 05-03-2018, 10:11 PM #1
    jamesldavis1
    jamesldavis1 is offline
    Registered User
    Join Date
    02-01-2014
    Location
    uk
    MS-Off Ver
    Excel 2013
    Posts
    6

    How to make a referenced cell become a certain value based on a desired final output?

    So say A1 is 100 and A2-A20 are "above cell*B$2$) and B2 is an interest rate I want to find the value of based on a desired finishing value in A20 of 1000. How would I write that in B2?
    Reply With QuoteRegister To Reply
  2. 05-03-2018, 10:21 PM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,895

    Re: How to make a referenced cell become a certain value based on a desired final output?

    You will need to use the Goal Seek function.

    https://www.timeatlas.com/excel-goal-seek/
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to use cell reference. I added a sheet which include raw data and final output
    By Neil28300 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-07-2015, 04:41 AM
  2. Macro to get the total hours per week
    By mihaufo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-04-2014, 06:46 AM
  3. Creating a Final Estimate Form and a Final Materials List based on Worksheet Results
    By Crunched For Time in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 12-20-2013, 09:58 PM
  4. Make a referenced cell stick with the original cell coordinates when the source is moved
    By m1cetro in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-28-2012, 02:36 AM
  5. [SOLVED] Not getting desired output
    By mhtkhan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-09-2012, 01:09 AM
  6. Can't make a cell absolute when referenced to another worksheet?
    By jack.k in forum Excel General
    Replies: 10
    Last Post: 03-06-2012, 09:23 PM
  7. Format-want the final output
    By kiranindia1986 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-22-2010, 10:10 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1