+ Reply to Thread
Results 1 to 11 of 11

Have a cell = a specific number and change the corrispondence to adjust to the number?

  1. #1
    Registered User
    Join Date
    10-21-2015
    Location
    california
    MS-Off Ver
    excel 2007
    Posts
    31

    Angry Have a cell = a specific number and change the corrispondence to adjust to the number?

    Can you have a cell change 1 of the number to adjust to the equaled sum? EXAMPLE

    Say I have N3 value:130.00 my 130 is coming from 2 sells I3/M3 I3 value:1182.60 M3 value:9.0

    My I3 is value from =H3*C3 H3 value being: .1825 and my C3 value being 6480

    I want if I enter 120.00 in N3 to change my H3 and nothing else....sorry I am trying to make it simple lol.

  2. #2
    Registered User
    Join Date
    10-10-2015
    Location
    Houston
    MS-Off Ver
    2013
    Posts
    26

    Re: Have a cell = a specific number and change the corrispondence to adjust to the number?

    You can do a Goal Seek under What if Analysis under Data. Set Cell N3 to value 120 by changing cell H3

  3. #3
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    Re: Have a cell = a specific number and change the corrispondence to adjust to the number?

    Could you not just have cell H3 as

    Please Login or Register  to view this content.
    Thanks,
    HangMan

    You can say "Thank you!" by clicking Add Reputation below the post.
    Please, mark your thread [SOLVED] if you are happy with the solution.

  4. #4
    Registered User
    Join Date
    10-21-2015
    Location
    california
    MS-Off Ver
    excel 2007
    Posts
    31

    Re: Have a cell = a specific number and change the corrispondence to adjust to the number?

    OK thank you how would I do that for everything I need?

  5. #5
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    Re: Have a cell = a specific number and change the corrispondence to adjust to the number?

    It would really help if you uploaded a sample spreadsheet showing the expected outcome...

  6. #6
    Registered User
    Join Date
    10-21-2015
    Location
    california
    MS-Off Ver
    excel 2007
    Posts
    31

    Re: Have a cell = a specific number and change the corrispondence to adjust to the number?

    Quote Originally Posted by HangMan View Post
    It would really help if you uploaded a sample spreadsheet showing the expected outcome...
    how can I do that? some of this information I can't release.

  7. #7
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    Re: Have a cell = a specific number and change the corrispondence to adjust to the number?

    Can you create a sample using some dummy data?

  8. #8
    Registered User
    Join Date
    10-21-2015
    Location
    california
    MS-Off Ver
    excel 2007
    Posts
    31

    Re: Have a cell = a specific number and change the corrispondence to adjust to the number?

    Column1 Column2 Column3 Column4 Column5 Column6 Column7 Column8 Column9 Column10Column11Column12Column13
    1280 18 71.1 0.1777 0 0.1777 227.5 45 60 2.5 1.75 130.00 2
    10000 225 44.4 0.1544 0 0.1544 1543.75 562.5 150 2.5 11.88 130.00 5
    2000 50 40.0 0.2025 0 0.2025 405 125 60 2.5 3.08 131.35 2
    12448 100 124.5 0.0700 0 0.0700 871.36 250 150 2.5 6.67 130.70 5
    7920 250 31.7 0.1825 0 0.1825 1445.4 625 150 2.5 12.92 111.90 5
    1280 30 42.7 0.1825 0 0.1825 233.6 75 60 2.5 2.25 103.82 2
    4760 150 31.7 0.1825 0 0.1825 868.7 375 60 2.5 7.25 119.82 2
    8416.4 120 70.1 0.1825 0 0.1825 1535.993 300 120 2.5 7.00 219.43 4
    5560 104 53.5 0.1825 0 0.1825 1014.7 260 120 2.5 6.33 160.22 4
    2960 78 37.9 0.1825 0 0.1825 540.2 195 90 2.5 4.75 113.73 3
    3600 165 21.8 0.1825 0 0.1825 657 412.5 90 2.5 8.38 78.45 3
    6760 325 20.8 0.1825 0 0.1825 1233.7 812.5 150 2.5 16.04 76.91 5

  9. #9
    Registered User
    Join Date
    10-21-2015
    Location
    california
    MS-Off Ver
    excel 2007
    Posts
    31

    Re: Have a cell = a specific number and change the corrispondence to adjust to the number?

    Quote Originally Posted by garfield101 View Post
    You can do a Goal Seek under What if Analysis under Data. Set Cell N3 to value 120 by changing cell H3
    This is working but is there a way to make it automatically do the rest of my cells? says only 1 cell reference error

  10. #10
    Registered User
    Join Date
    10-10-2015
    Location
    Houston
    MS-Off Ver
    2013
    Posts
    26

    Re: Have a cell = a specific number and change the corrispondence to adjust to the number?

    I am not sure if you can do goal seek on a range without using some vba code.

  11. #11
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2013
    Posts
    4,337

    Re: Have a cell = a specific number and change the corrispondence to adjust to the number?

    @ michaelDDW

    To attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

    Regards,
    Vlady
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

+ 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. Auto- adjust cells to always add to a specific number/quantity
    By exelbeginner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2015, 07:24 AM
  2. [SOLVED] code to automatically change value of a cell from a number to a specific word
    By excel151515 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-07-2014, 02:47 PM
  3. [SOLVED] Count number of times a specific number is displayed in a cell ran
    By N Harkawat in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 12:05 PM
  4. [SOLVED] Count number of times a specific number is displayed in a cell ran
    By subs in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. [SOLVED] Count number of times a specific number is displayed in a cell ran
    By N Harkawat in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 04:05 AM
  6. [SOLVED] Count number of times a specific number is displayed in a cell ran
    By subs in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  7. [SOLVED] Count number of times a specific number is displayed in a cell ran
    By subs in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11: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