Jump to content

Is it possible to find for any unknown in equation if...


This topic is 6240 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello,

I've searched around, but I haven't found a solution for my problem.

I need to be able to find the unknown in an equation when all other variables are known. for example: if A+B=C and I know B and C, I want A to automatically calculate.

The tricky part is that I'm hoping to be able to have the A,B, and C fields empty and typing the values into any two will produce a result in the third. For example: Fields A, B, and C are blank. If I type 2 into Field A and 5 into Field C, Field B will show 3. If I delete the 5 from Field C and put a 4 in Field B, I want Field C to automatically show 6.

Is this possible? If not, is there a close workaround?

The calculations will be used in Time Value of money equations. The real variables will be Principal (Future Value), Interest Rate, Terms (in Years), and Monthly payment.

Thanks in advance for your help1

Sol

Edited by Guest
Link to comment
Share on other sites

Hi Shadow,

Thanks for the reply. I'm actually using 8.5 (I guess I didn't update the profile...).

Anyways, I tried using the Auto-enter. That seems intuitive, but when I put a value into a blank field, the field goes blank as soon as I go to the next field. What am I missing?

Thanks for your help.

Sol

Link to comment
Share on other sites

change the field to a calculation field, it will then update fie field, and then change it back to Auto Enter.

HTH

Lee

[color:red]p.s.

Try this on a copy of the file

Edited by Guest
p.s.
Link to comment
Share on other sites

Thanks Lee.

That worked 1 time, but I need it to evaluate over and over again. I want to be able to do "What If" scenarios. For example: What if A was 1 and B was 3; OK C is 4. Now what if I change B to 4; OK C is 5.

Hope that is more clear.

Link to comment
Share on other sites

Good point Ray. I was thinking about that and trying to figure out a way to provide a radio button that says "Solving for:" whichever value. In that case, the calculation would reference the radio field in a Case statement. For example: Case (Radio = "A"; Solve for A; Radio = "B"; solve for B; Radio = "C"; solve for C; default).

That way the equation wouldn't be stuck with not knowing which variable is the one that needs to be changed.

Do you think that using something like this could provide the answer?

Link to comment
Share on other sites

I hate when I overcomplicate things. I had been looking at their techniques for something similar to what they did, and I guess that was on my mind and I wasnt thinking. My head has been in la-la-land all day. Thanks for the correction and reality check Comment.

Link to comment
Share on other sites

Hmmm... I have C selected, and I modify B - and I see A getting adjusted. I don't think you can achieve what I think you are trying to achieve, for the reasons explained in your first post.

I actually did something like this a long time ago, but I chose a different approach altogether (sceenshot attached).

FA.png

Link to comment
Share on other sites

Hmmm... I have C selected, and I modify B - and I see A getting adjusted.

Isn't that what he wish and what my file do ?

Fix C Set A Obtain B

Fix A Set B Obtain C

Fix A Set C Obtain B

... and so on ?

... for the reasons explained in your first post.

with a value fixed, the result is only one.

Link to comment
Share on other sites

I thought the 'solve for' field is the one that is supposed to change. If instead you want the field to be 'fixed', then suppose C is selected, and I modify C - I see A getting modified, although it could just as well be B.

I know that what I do is not reasonable, but it is possible, so why not? It only shows that this type of user interface is, at least partially, 'undefined'.

Link to comment
Share on other sites

This topic is 6240 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.