solve complex equations in excel function
It would be nice if we could solve engineering non-linear equations in Microsoft excel. Solver add-on does it but its very complicated. It would be nice if there is a formula like sum, min etc...
Microsft excel team could create a function : solve(equation,variable needs to be soved, range for solution )
for eg: if I need to solve 2(x^3)+5=0
then i would type =solve(2*(a1)^3+5==0,a1,[0 10])
The constants described above could also come from excel sheet.
I hope I made it clear. I am almost done with engineering but this function could really help young engineers :)