If, Then, ElseIf statement solves (using solver) for two of my criteria and returns, but will not solve for the third. No error messages either
I am trying to use VBA to solve for a variable to get three different returns: 10%, 16%, Breakeven. I have to use solver to avoid circular references, but I have 5 different scenarios to solve for all three criteria on. So, I thought automating the solver process would speed things up tremendously.