+ Reply to Thread
Results 1 to 7 of 7

Back and Forth Input Formula

  1. 09-12-2013, 05:06 AM #1
    LokeYourLord
    LokeYourLord is offline
    Registered User
    Join Date
    09-12-2013
    Location
    Norwegen
    MS-Off Ver
    Excel 2013
    Posts
    3

    Angry Back and Forth Input Formula

    So i want to make a formula that stays at its cell. I want to make the electrical U=R*I, R=U/I and I=U/R.

    Capture.PNG

    When i input something at U and R i want I out. If i change the value at I and U, it shall give me the right R value. So i want back and forth formula. Like those
    arrows that come up when you do for example:
    G11=G12*G13
    G12=G11/G13
    G13=G11/G12

    Then some blue arrows come up to tell us that one Cell is dependent on another. How do i make it permanent, so the formulas stay in the cells, even if i replace them. I just want the it easy: I know 2 things, and i want the third. I put in U and I, to get R. I know R and U, to get I.
    Reply With QuoteRegister To Reply
  2. 09-12-2013, 06:18 AM #2
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Back and Forth Input Formula

    you cant as once you put a value in the cell you overwrite the formula and as you have found out you get circular references
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
  3. 09-12-2013, 07:24 AM #3
    L-Drr
    L-Drr is offline
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Wageningen, The Netherlands
    MS-Off Ver
    365
    Posts
    495

    Re: Back and Forth Input Formula

    In the attachment is a different approach of your problem, that get's you the answer you need.
    Attached Files Attached Files
    When I say semicolon, u say comma!
    Reply With QuoteRegister To Reply
  4. 09-12-2013, 12:36 PM #4
    LokeYourLord
    LokeYourLord is offline
    Registered User
    Join Date
    09-12-2013
    Location
    Norwegen
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: Back and Forth Input Formula

    thank you all :D i check it out thanks :D
    Reply With QuoteRegister To Reply
  5. 09-12-2013, 12:39 PM #5
    LokeYourLord
    LokeYourLord is offline
    Registered User
    Join Date
    09-12-2013
    Location
    Norwegen
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: Back and Forth Input Formula

    Quote Originally Posted by L-Drr View Post
    In the attachment is a different approach of your problem, that get's you the answer you need.
    thanks it works. only problem is, that R is not working. can you fix that? then its ok :D you helped me alot :D

    i got it work :D you used C2/B2 instead of C3/B3 :D thanks alot though :D
    Last edited by LokeYourLord; 09-12-2013 at 12:45 PM.
    Reply With QuoteRegister To Reply
  6. 09-12-2013, 02:49 PM #6
    L-Drr
    L-Drr is offline
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Wageningen, The Netherlands
    MS-Off Ver
    365
    Posts
    495

    Re: Back and Forth Input Formula

    Great!

    Please mark the thread as solved (above your first post under Thread Tools) and consider adding reputation to those who helped you (click the star on the lower left corner of someone's post).
    Reply With QuoteRegister To Reply
  7. 09-29-2013, 10:05 AM #7
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Back and Forth Input Formula

    I've marked this thread as SOLVED for you.
    Next time, select Thread Tools from the links above to mark a thread as SOLVED. Thanks.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    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. VBA Macro to input values into web form and then click button and get results back
    By Benisato in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2013, 10:15 AM
  2. Populate multiples rows with data, then loop back and get next next row of input.
    By bungslea in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-09-2013, 07:16 AM
  3. Help: Reset input data back to original
    By jasonj427 in forum Excel General
    Replies: 5
    Last Post: 01-22-2013, 01:49 AM
  4. [SOLVED] Input Box, Confirm yes/no, if answer = no, loop back to input box
    By lukasj13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-30-2012, 12:41 PM
  5. Font changed for VBA input, attempt to change back crashes Excel - how to resolve?
    By martinp1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2012, 09:50 AM

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