其中E列的值为B、C、D列值的函数E=f(B、C、D)
将solver写成宏,就不用一个一个点求解按钮了,得到的值还会再写到F列中
参考资料:
https://www.ppchero.com/how-to-automate-excel-solver/
https://www.ppchero.com/how-to-get-more-out-of-excel-solver/
https://www.ppchero.com/how-to-use-excel-solver-to-optimize-your-campaign-budgets/
https://learn.microsoft.com/en-us/office/vba/excel/concepts/functions/solversolve-function#solversolve-return-value
https://answers.microsoft.com/en-us/msoffice/forum/all/solver-vba-solversolve-return-tell-me-status-of/8bfb679f-337c-4d01-91de-d3d7c36634e0
https://www.google.com.hk/search?q=excel+solve+equation+root&newwindow=1&sca_esv=779b01740ca52ec5&rlz=1C1GCEB_en__1095CN1097&ei=Fj8qZrKPBpaN4-EPhKKwuAQ&ved=0ahUKEwiy8vuIot2FAxWWxjgGHQQRDEcQ4dUDCBA&uact=5&oq=excel+solve+equation+root&gs_lp=Egxnd3Mtd2l6LXNlcnAiGWV4Y2VsIHNvbHZlIGVxdWF0aW9uIHJvb3QyBRAhGKABSPUzULIJWIAycAJ4AZABAJgBxgGgAfIaqgEEMC4yMLgBA8gBAPgBAZgCFaAC3hnCAgoQABiwAxjWBBhHwgIFEAAYgATCAgcQABiABBgMwgIIEAAYgAQYogTCAgQQABgewgIGEAAYCBgewgIGEAAYBRgewgIHEAAYgAQYE8ICBhAAGBMYHsICCBAAGBMYBRgemAMAiAYBkAYCkgcGMi4xOC4xoAfQQA&sclient=gws-wiz-serp#fpstate=ive&vld=cid:c0aebd4d,vid:IwMr5-cp0Cw,st:0
https://blog.csdn.net/s_156/article/details/128670419?spm=1001.2101.3001.6661.1&utm_medium=distribute.pc_relevant_t0.none-task-blog-2%7Edefault%7EOPENSEARCH%7ERate-1-128670419-blog-138307842.235%5Ev43%5Epc_blog_bottom_relevance_base8&depth_1-utm_source=distribute.pc_relevant_t0.none-task-blog-2%7Edefault%7EOPENSEARCH%7ERate-1-128670419-blog-138307842.235%5Ev43%5Epc_blog_bottom_relevance_base8&utm_relevant_index=1