Converting a math formula into excel formula - the ";" sign

Hi Forum!

It's my second thread in your forum, after making a mistake with the first one. I'm still learning rules and the way your forum goes... I hope some tolerance, please, not least because I also intend to remain as an active participant, sharing work or doubts in financial matters or even in applications for law field.

Eternally grateful already.

My problem is that I don't know how to code a math formula into an excel formula. Can you help me please, giving me some advice or even a solution?

The math formula is this one (made by me - I hope it will solve my problem):

xy=(2133y-xy)*(0.094*15)

I know this ends as...

x=300753/241 ; y≠0

Would it be preferable to code the enunciation problem or the solution? (I think it would be betterto code the enunciation; this way I would be able to transform it into an abstract formula to solve the same problem with different values in future...)

If I should code into an excel formula the enunciation of the mathematical problem, how can I translate the "=" sign in an excel formula?

Or if you think it's better to take the final result...

What's the meaning here of ";" sign? How should i translate it in an excel formula?

Thank you very much for your kindness and attention.

My best regards.

Hi,

I'm not sure what you're asking.
Are you saying that you have two cells which hold the values of x & y and that you want the result of
(2133 * y) - (x * y) * (.094 * 15)

I don't understand what you mean by

I know this ends as...

x=300753/241 ; y≠0

Perhaps it would help if you'd upload a workbook and manually add the results you expect to see, clearly identifying the result cells.

I'm not sure I understand what you are asking. If I understand, I would not program either of those into Excel. I don't know if you want to call it a "hybrid" approach between the two you have given. Normally, what I would do would look something like this.

1) Replace constants with a suitable variable. Perhaps this looks like xy=(ay-xy)*bc
2) Solve for the unkown (x in this case), which should be the same thing you did before, only leave the "constant" computations undone. If I did the algebra right, I get x=abc/(bc-1) (which appears to be different from what you got). With a cell each for a,b,c (and y, if I want to check for the y=0 part, since I did have y/y at one point in the algebra which does mean that y cannot be 0), I can then program the formula for x, and compute x. As the values for a,b,c, and y change, my formula will update with those changes.

Without doing the algebra again, I can't be sure. I know that losing a minus sign was always one of my favorite algebra mistakes. You just need to do the algebra carefully enough to decide which one of us lost a minus sign in the process.

I've tried it, with both, but it seems that somenthing it's already missing... and probably the problem is in the mathematical solution that I thought it would be better to solve the problem. Would it be a function or an simple equation or something else... I think it should be something that would give me the optimal solution to sell one part and gather the money enough to pay this way the maximum number of rights in underwriting process.. I don't know which way in maths should i take... (It's not my field even i have some knowledge in it, but, as seen, not enough yet to this problem... I'm trying to learn it so i can be able to work with financial math at high level, but this takes time; I've studied law - Humanities - but i should have studied math instead... I love it... but the way is still long enough...). Once i have the answer, i'll come here to post it... I hope i still can find it today.

A big, big thank you to you, and for all of you for your kindness and generosity.

A big hug to you.