Hi,

I need to use excel to calculate a link budget. Everything is fine except that I have to solve a rather complex equation for the propagation model.

Is there an Excel function that will let me solve for X by approximation?

Trivial example: 132=log(x/100)+log(y/z)

I have a Casio calculator that will do this. You write the formula and you tell it what’s your best guess for X. It will start by giving X some value and see if both sides of the equation are equal, if not, it then tries another, then another, and step by step it approximates until it gets it to like 8 digits of precision. This is not a sophisticated calculator so I think excel must have something like this built in...

I know I could rearrange the formulas, but they are all very complex. I need to try several different models and I don’t really have much time. I tried to solve some of them but I never quite got them right, even using a CAS the result wasn’t quite right... at this point the easiest way it to let excel approximate stuff.

Any suggestions?

Thank you all.