{"id":72,"date":"2018-12-26T16:13:32","date_gmt":"2018-12-26T16:13:32","guid":{"rendered":"https:\/\/www.howtoexcel.info\/Excel\/?p=72"},"modified":"2021-09-29T06:06:05","modified_gmt":"2021-09-29T06:06:05","slug":"excelsolver-2003","status":"publish","type":"post","link":"https:\/\/www.howtoexcel.info\/Excel\/excelsolver-2003\/","title":{"rendered":"Solving Equations in MS Excel 97-2003 version"},"content":{"rendered":"\r\n<p align=\"left\"><span style=\"color: #000000;\">Let us see how to solve the following equations using excel solver option in MS Excel 97 to 2003 versions.<\/span><\/p>\r\n<p align=\"left\"><span style=\"color: #000000;\"><b><span style=\"font-size: xx-large;\">12x+25y+687z=9<\/span><\/b><\/span><\/p>\r\n<p align=\"left\"><span style=\"color: #000000;\"><b><span style=\"font-size: xx-large;\">45x-24y+78z=12<\/span><\/b><\/span><\/p>\r\n<p align=\"left\"><span style=\"color: #000000;\"><b><span style=\"font-size: xx-large;\">567x+2y-7z=123<\/span><\/b><\/span><\/p>\r\n<p align=\"left\"><span style=\"color: #000000;\">Solution:<\/span><\/p>\r\n<p align=\"left\"><span style=\"color: #000000;\">1. Open excel and go to tools<\/span><\/p>\r\n<p align=\"left\"><span style=\"color: #000000;\">2. See if there is an option called solver. By default this option will not be installed in excel.<\/span><\/p>\r\n<p align=\"left\"><span style=\"color: #000000;\">3. If the solver is not installed, go to tools, add-ins<\/span><\/p>\r\n<p align=\"left\"><span style=\"color: #000000;\">4. In add-in, select &#8216;Solver&#8217; and click ok<\/span><\/p>\r\n<p align=\"left\"><span style=\"color: #000000;\">5. Insert the Microsoft office CD on demand.<\/span><\/p>\r\n<p align=\"left\"><span style=\"color: #000000;\">Now let us see how to solve the equation using solver.<\/span><\/p>\r\n<p align=\"left\"><span style=\"color: #000000;\">For this you need 3 columns A, B and C. (We need the result to appear in the column C (x, y and z in C1, C2 and C3 respectively)<\/span><\/p>\r\n<ul>\r\n<li>\r\n<p align=\"left\"><span style=\"color: #000000;\">In A1 enter the formula\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 12*C1+25*C2+687*C3<\/span><\/p>\r\n<\/li>\r\n<li>\r\n<p align=\"left\"><span style=\"color: #000000;\">Similarly in A2 enter the formula\u00a0\u00a0\u00a0\u00a0\u00a0 45*C1-24*C2+78*C3<\/span><\/p>\r\n<\/li>\r\n<li>\r\n<p align=\"left\"><span style=\"color: #000000;\">Similarly in A3 enter the formula\u00a0\u00a0\u00a0\u00a0\u00a0 567*C1+2*C2-7*C3<\/span><\/p>\r\n<\/li>\r\n<li>\r\n<p align=\"left\"><span style=\"color: #000000;\">Enter the values 9, 12 and 123 in B1, B2 and B3 respectively.<\/span><\/p>\r\n<\/li>\r\n<li>\r\n<p align=\"left\"><span style=\"color: #000000;\">Now open solver from tools menu<\/span><\/p>\r\n<\/li>\r\n<li>\r\n<p align=\"left\"><span style=\"color: #000000;\">Clear the contents of &#8216;set target cell&#8217;<\/span><\/p>\r\n<\/li>\r\n<li>\r\n<p align=\"left\"><span style=\"color: #000000;\">In &#8216;by changing cell&#8217;, select C1, C2 and C3 by dragging<\/span><\/p>\r\n<\/li>\r\n<\/ul>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.howtoexcel.info\/Images\/Solver-2003\/solver.GIF\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.howtoexcel.info\/Images\/Solver-2003\/3.GIF\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.howtoexcel.info\/Images\/Solver-2003\/2.GIF\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"color: #000000;\">In &#8216;subject to constraints&#8217;, click add<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.howtoexcel.info\/Images\/Solver-2003\/4.GIF\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"color: #000000;\">For &#8216;cell reference&#8217; select data range A1, A2, A3<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.howtoexcel.info\/Images\/Solver-2003\/5.GIF\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p align=\"left\"><span style=\"color: #000000;\">In the middle column, select &#8216;=&#8217; simbol<\/span><\/p>\r\n<p align=\"left\"><span style=\"color: #000000;\">In the constraint, select data range B1, B2, B3<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.howtoexcel.info\/Images\/Solver-2003\/6.GIF\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p align=\"left\"><span style=\"color: #000000;\">Click OK<\/span><\/p>\r\n<p align=\"left\"><span style=\"color: #000000;\">Now the solver parameters look like this<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.howtoexcel.info\/Images\/Solver-2003\/7.GIF\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"color: #000000;\">Click solve on the solver window<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.howtoexcel.info\/Images\/Solver-2003\/8.GIF\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"color: #000000;\">Click OK on the next window.<\/span><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/www.howtoexcel.info\/Images\/Solver-2003\/result.GIF\" alt=\"\" \/><\/figure>\r\n\r\n\r\n\r\n<p><span style=\"color: #000000;\"> Now you get the solution the these equations in the cells C1, C2 and C3.<\/span><\/p>\r\n<p>&nbsp;<\/p>\r\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/72"}],"collection":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/comments?post=72"}],"version-history":[{"count":5,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/72\/revisions"}],"predecessor-version":[{"id":274,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/posts\/72\/revisions\/274"}],"wp:attachment":[{"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/media?parent=72"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/categories?post=72"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.howtoexcel.info\/Excel\/wp-json\/wp\/v2\/tags?post=72"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}