Hi Most users use the Simplex when it is a linear problem - as we have it here. I avoid the nonlinear when the problem is linear. This problem show...
Hi Thank you for your email and question. Your problem setup is perfect. The Solver needs one minor change: If you run the Solver with the Simpl...
It is difficult to answer the question without data. One thing, is to try and chart the two values over time (transaction amount x fee vs. number ...
Alfie Thank you for your question. This is an Excel for Finance module/class and we focused of how to use Excel to calculate, among other functio...
Frank Thank you for your question. See attached reply and workbook.
Thank you for your comment. You are correct the correlation is for the range of E:F and not E:G.
This is a great question. As the name of the feature What-If-Analysis does exactly what is meant to say. For your “values in orange”: These are ...
Hi Stefano Great question. =RANDBETWEEN(8,12) will give you the same answer as =INT(RAND()*5)+8. The reason you will not get 13 out of INT(RAND()*...
Hi there This is a good idea. I will do it in a couple of weeks. I am traveling through mid-November. Isaac
Dear Yan The answer to your question starts in the middle of the recorded session (about 4:00 minutes from the binning of the session.) We link ...
Per Thank you for your question. It mat happen to others as well. Please try again. Hold the CTRL+SHIFT down (and do not release) and hit Enter....
Hello Thank you for your kind words. The Data Analysis is choosing the data randomly and it will probably have the same distribution as the orig...
Thank you. I think it is clear. The Analysis TooiPak's output is easy to follow. If you select "Labels in First Row" - the results will be obvious in ...
Philip It will be much easier to use a project management software (many of them are free) that to try to use Excel to do it. Isaac