Share via

Equation Solver in Excel

Anonymous
2021-06-13T22:32:27+00:00

anyone who can tell me how to solve such a system of equations in excel

m1/m2=45/55

0.15m1+m2=0.667

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2021-06-15T11:24:00+00:00

Hi. Oh. By "Equation Solver", you meant Solver.

I thought you wanted a direct way to solve it.

The direct way...

m1/m2=45/55

Make it linear by multiplying both sides by m2

m1 = (45/55) m2

bring it to the left

m1- (45/55) m2 = 0

->

m1- (9/11) m2 = 0

I made the "assumption" that 0.667 was 2/3.

I entered the equation in B5

Image

Was this answer helpful?

2 people found this answer helpful.
0 comments

Answer accepted by question author

Anonymous
2021-06-15T08:33:51+00:00

Hi DiiiZiii,

I found an article which can help solve the equation. Here’s the article for your reference:

Solving Equations using Excel Solver

***Third-party link disclaimer:***Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.

I tried to solve the equation and based on article. follow the steps: :

Enter the destination range in the box ‘By changing variable cells’ (select C1 and C2 by dragging)

Enter the constraints inside the box ‘Subject to the Constraints’ by clicking the ‘Add’ button as below.

Click Solve>Ok, now you get the solution of these equations in the cells C1 and C2.

Regards,

Neha

Was this answer helpful?

2 people found this answer helpful.
0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-06-15T15:13:51+00:00

    You are great @Dana Di

    Thank you so much and I think I have lost my mind because i was stuck at this point where I was supposed to take the "45/55*m2" term on the left side. Btw. Thank you for your cooperation.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2021-06-15T05:38:08+00:00

    Thank you but could more briefly tell me what to do next because i am really trying to do these calculations but am unable. It pop ups an error every time I try to solve.

    After making it linear then how could we insert values in the solver?

    Was this answer helpful?

    0 comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more