• 546K Members
• 2,631 Online
• 652K Conversations

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

Highlighted
Occasional Visitor

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

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.

Highlighted

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

Firstly, why not rearrange the formula

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

=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
Conditional formatting with wildcard
Rajeev_Raghavan in Excel on
0 Replies
Inconsistency error in the MROUND function
Fleischbender in Excel on
0 Replies
#OVERLOOP!