+ Reply to Thread
Results 1 to 5 of 5

Find the X

  1. #1
    Registered User
    Join Date
    10-21-2018
    Location
    Brazil
    MS-Off Ver
    16
    Posts
    22

    Find the X

    I have a simple equation (that I've made even simpler here) that I can only solve it manually...
    The equation is the following: "1/(1+1+1+X)" and I want the result to be "0,2". For this example, the X must be the number 2.

    1/(1+1+1+2)=0,2

    How I can do it automatically without having to manually choose the X value?

    The result must always be 0,2, unless I want the end result to be 0,27 for example. But anyway I'll always have the final result, just need to find the X in each case.

    Few more examples:
    1/(1+1+2+X) = 0,23 X = 0,34783
    1/(1+1+1,5+X) = 0,1818 X = 2

    So, any tips besides returning to school?

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,704

    Re: Find the X

    A bit of algebraic manipulation will give us:

    X = (1 - 3N) / N

    where N is the number you quote above, like 0.2 and 0.23. If you use A2 to record that value, then you could have this formula in B2:

    =(1-3*A2)/A2

    Hope this helps.

    Pete

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,704

    Re: Find the X

    Actually, you seem to have this:

    1 / (1 + 1 + M + X) = N

    so if you rearrange this you get:

    X = (1 - 2N - MN) / N

    where N could be cell A2 and M could be A3.

    Hope this helps.

    Pete

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,289

    Re: Find the X

    see also this excel example
    Attached Files Attached Files
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  5. #5
    Registered User
    Join Date
    10-21-2018
    Location
    Brazil
    MS-Off Ver
    16
    Posts
    22

    Re: Find the X

    Thanks guys! This was exactly what I needed! Took me around 3 cells to make the equation... So more beautiful in just one cell.
    Really appreciate it!

+ 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. Replies: 3
    Last Post: 01-15-2019, 03:58 AM
  2. Find 1 returns error if Find 2 is present in User form Search box
    By alexgoaga in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2018, 05:46 AM
  3. Replies: 3
    Last Post: 08-18-2015, 09:04 AM
  4. Replies: 9
    Last Post: 12-21-2014, 06:29 PM
  5. Replies: 4
    Last Post: 09-18-2012, 10:54 AM
  6. Find Macro With Userform - To find a data across multiple tabs in excel
    By Testify in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-15-2012, 04:49 PM
  7. Replies: 1
    Last Post: 01-31-2006, 06:25 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