+ Reply to Thread
Results 1 to 5 of 5

Want the final value = 7, what is the formula?

  1. #1
    Registered User
    Join Date
    07-31-2019
    Location
    HONG KONG
    MS-Off Ver
    EXCEL 2016
    Posts
    48

    Want the final value = 7, what is the formula?

    Hi
    Please kindly see attached picture.
    I want a formula that make the final value in Red text = 7, What is the value shoud be for yellow color cell?
    thanks a lot.
    Attached Images Attached Images

  2. #2
    Forum Expert Logit's Avatar
    Join Date
    12-23-2012
    Location
    North Carolina
    MS-Off Ver
    Excel 2019 Professional Plus - 2007 Enterprise
    Posts
    7,015

    Re: Want the final value = 7, what is the formula?

    Paste in F2:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-17-2016
    Location
    Cumming, GA
    MS-Off Ver
    XL10
    Posts
    8

    Re: Want the final value = 7, what is the formula?

    Note: I am using the posters column headers of A,B,C,G etc. etc. and not the EXCEL columns.

    If I understand you correctly, you are not needing a formula - you just need a value provided for an existing formula where the result will be 7

    (J14+G14)/H14 = 7
    (J14+(A14-B14-C14)/H14 = 7
    (3700+1180-650-C14)/253.33 = 7
    MULTIPLE BOTH SIDES BY 253.33
    (3700+1180-650-C14) = 1773.31
    (4230-C14)= 1773.31
    SUBTRACT 4230 FROM BOTH SIDES
    (-C14) = -2456.69
    MULTIPLE BOTH SIDES BY -1
    (C14) = 2456.69

    PROOF
    (J14+G14)/H14 = X
    (J14+(A14-B14-C14)/H14 = X
    (3700+(1180-650-2456.69)/253.33 = X
    (1773.31)/253.33 = X
    (7) = X

    And if I misunderstood your need, I apologize

    So, 2456.69 is the value you seek
    Last edited by svance; 10-06-2019 at 10:24 PM. Reason: CLARIFICATION

  4. #4
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,921

    Re: Want the final value = 7, what is the formula?

    (J14+G14)/H14 =7

    => (J14+G14)=H14*7

    => G14=H14*7-J14

    => C14=-H14*7+J14+A14-B14

    Formula in C14: -H14*7+J14+A14-B14
    Last edited by Phuocam; 10-06-2019 at 10:29 PM.

  5. #5
    Registered User
    Join Date
    07-31-2019
    Location
    HONG KONG
    MS-Off Ver
    EXCEL 2016
    Posts
    48

    Re: Want the final value = 7, what is the formula?

    thanks a lot. it works

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to Populate final Row of duplicate Rows
    By partyrental in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-13-2019, 10:21 AM
  2. [SOLVED] final date formula not work
    By max_max in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-14-2017, 03:23 PM
  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. [SOLVED] Formula Help - Removing Everything to the right of final hyphen
    By zippyfrog in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-20-2012, 09:25 PM
  5. replacing lowest test grade with final if final is higher formula help
    By colbyclay in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-16-2012, 02:48 AM
  6. Final Grade Formula
    By skwiskwis in forum Excel General
    Replies: 3
    Last Post: 12-19-2010, 03:17 PM
  7. Formula to pull the final value in a column
    By 2709236 in forum Excel General
    Replies: 2
    Last Post: 06-15-2009, 02:12 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