Im attempting to get excel to calculate the length of a side of a triangle using the formula =(a/SIN(A2)-34.4/SIN(B2)), where a is an unknown variable. Any help would be great. thanks.
Firstly, why not rearrange the formula
Other options include calculating your formula for a whole range of values for 'a' and spotting the point at which it crosses zero or using goal seek to set 'a' to give zero. Solver is over-kill.