Hi there all.
I have an equation as part of a long algorithm

a * cos (A) + (b-f) sin (A) - p * cos^2(A) = 0

The solution of which I need is A = 0

I have variables for a,b,f&p entered in cells (say a1,a2,a,3,a4) the angle (A) could be between 0,90

Now then the result for say if a=1430 b=1651 f=7984 & p=600 would be close to 7.5124035 (although that answer actually returns 0.00076703 and not 0)

I had originally thought it would be enough to run the equation in a spreadsheet with the variables in a box and then run the calculation 900 times and vlookup the nearest to 0 bu0t have found that even withthe number setting set to no decimal places I need at least 4 decimal places. That would mean I would need to run the calculation 900*900*900&^*&% alot of times.

I could round the number but then I'm likely to get more than one answer.

Is there an easier way of doing this acurately without resorting to lookup closest match???


cheers
Nobby