Attempting to use solver on MacOS Catalina, I am getting the message above.
Problem I am trying to solve is defining a bond yield based on Future Value and Coupon rate using a gap intermediary value.
the formula is = c/1+y + (FV+c) / (1+y)^2
where c = 3
FV= 100
P= 96
gap = FV - P
y = is the value I am trying to solve
In solver
Target Cell hold the gap formula FV - P
It optimizes the results to get a value of 0
by changing the cell that holds y
there are no limiting conditions
Thanks!