|
Click the Data tab. Then click the Solver button.
|
|
![Click the Data tab. Then click the Solver button.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_stb9QaHYX7VU9y4MmKsz96cYxsaHYGOn2gE6TNCoH5GTX52SK66meh6COlJHI__WrzYjSkRS1d5P_fsefagPyN90pYc1n5l8QNSN2ja7ksTjl9_nRBsk0noPY22ZF3ZRcEDBk_uHw14xV7JH90CCoCBTCG3H0cdkEB8MCfBdWV1C-6JDkqBvv4yI5gWSiMJX71BaWvawaYgA=s0-d) |
|
![Select the target cell.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_s5amfSs-KD_QFZPSF75hr0FDcWsvliDhhHE8fXiiyiwjSDdOV5ZKj_Cnl703gHsPRyuiDJ_MYuTlcgTrZpjnpJQZ07FfE_b1Y5-HudsI2IATpDg0xo9ZVpIPuJwrl7jl91C_ZpH1glharCf8HVAiCmwPK9lEJzf0DsO-uf_z5frDGM-zyZCTA=s0-d) |
Click an Equal To option, and then, if necessary, enter a value.
|
|
![Click an Equal To option, and then, if necessary, enter a value.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_uETPXtLijeQvTKXzHRw_ptrChfCzJ_iAtoLNkpbXoMO__ux4vWCTb0M7_D0yFkwVVVpHO5AQbk5GQqtLywgkvyVEFdPFmJN2bBLniYGBxCo7WjZ4MBzYDT-Tq-VVK_hobZWHZsLEsWDHD3hdZ59MCw-QVLcFFhkMwN0vtcTCa1_Yvtz_h-Yeu05oNwJZxCVcEL1z6nA1vaxw=s0-d) |
Select the cell range the solver uses to compare against the target cell.
|
|
![Select the cell range the solver uses to compare against the target cell.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_tSyxavbwWJrDtTo28iVIZAN1CL1OxWWuhL8N8NLy1fKcOzb2lRu9Spm0yixHRzcNqy_1GmmclcvgWGDwpq6wCaosy--7fmID6pcpQtXOT9rCRo7gw_SfkcRuhXlONcCsg_Zxa-UIhUQRFbUZft1qv6iMMNPC6qmTcmNhpeo6vKl5DtS8njunPkdKqnDKEf3C-p5TxdZUf8jw=s0-d) |
|
![Click Add.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_tmlqt97biRz6IUd-Vj7rVOIdGzVvhu2TmBYuF1C8uhYc-i8oBwqdODFGprJbfKbuxcil-E6vuOaVFC-S546zU5z6EQUCcUWsGXdtUQGHrp-5HVujLy4mIH9KlJ1BaSLTIjzkbFB05IPSQdEqwLA5ZcsefVK0pFeYZP4e8TfQ=s0-d) |
Enter specific cell reference and constraint, and then click Add. Click OK.
|
|
![Enter specific cell reference and constraint, and then click Add.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_stm5udLtXHJ5vu5Jek8TxhXL0rxON89ltw9AzNAquJO06LnTYdrKBjMmxNZzX0JP5jTXMiSP9XYQfWSc1KvQI4P4oBZw-A-SffxwROR1NcCi6BergVJFTFKvzyOmRq24WkKBEa4BiDYVS1JLr3qV60P_rbJy82qGFbC3qGJO2OAWRbZea1bpyDOEgtglbVjZlK3mMNnoJ0=s0-d) |
|
![Click Solve.](https://lh3.googleusercontent.com/blogger_img_proxy/AEn0k_uAza_XANIJq_HiUjVRnSIiBNeuLwu0jN8NkNbqktrjaPtX9vIPjyuFY2_4iiNTLEO05bO6m1Q82xma6_K1t7daONGjjwoky9U-v0aTwzl2V0HegC2PbmatfmZk8w8EPLhNkxUqwCxo7haD84ySvx0XUNr6_fKoUmWqL96kpUFv=s0-d) |
If the Solver finds a solution, the Solver Results dialog box opens. Click the Keep Solver Solution option. Click a report type. Then click OK.
|
|
No comments:
Post a Comment