Home

How do I solve for an unknown variable from an equation using solver in Excel?

%3CLINGO-SUB%20id%3D%22lingo-sub-614273%22%20slang%3D%22en-US%22%3EHow%20do%20I%20solve%20for%20an%20unknown%20variable%20from%20an%20equation%20using%20solver%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-614273%22%20slang%3D%22en-US%22%3E%3CP%3EIm%20attempting%20to%20get%20excel%20to%20calculate%20the%20length%20of%20a%20side%20of%20a%20triangle%20using%20the%20formula%26nbsp%3B%3D(a%2FSIN(A2)-34.4%2FSIN(B2))%2C%20where%20a%20is%20an%20unknown%20variable.%20Any%20help%20would%20be%20great.%20thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-614273%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-614431%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20solve%20for%20an%20unknown%20variable%20from%20an%20equation%20using%20solver%20in%20Excel%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-614431%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F344735%22%20target%3D%22_blank%22%3E%40Adam_s299020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFirstly%2C%20why%20not%20rearrange%20the%20formula%3C%2FP%3E%3CP%3E(a%2FSIN(angleA)-34.4%2FSIN(angleB)%3C%2FP%3E%3CP%3Eto%20read%3C%2FP%3E%3CP%3E%26nbsp%3B%3D34.4*SIN(angleA)%2FSIN(angleB)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOther%20options%20include%20calculating%20your%20formula%20for%20a%20whole%20range%20of%20values%20for%20'a'%20and%20spotting%20the%20point%20at%20which%20it%20crosses%20zero%20or%20using%20goal%20seek%20to%20set%20'a'%20to%20give%20zero.%20Solver%20is%20over-kill.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Adam_s299020
Occasional Visitor

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.

1 Reply

@Adam_s299020 

Firstly, why not rearrange the formula

(a/SIN(angleA)-34.4/SIN(angleB)

to read

 =34.4*SIN(angleA)/SIN(angleB)

 

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.

 

Related Conversations