Learn How to Calculate Unknown Variables in Excel: Step-by-Step Guide

  • Thread starter Thread starter Baybora
  • Start date Start date
  • Tags Tags
    Excel
Click For Summary
To calculate two unknowns from two equations in Excel, set up the equations in separate cells. Use Excel's Solver tool to define the objective and constraints based on the equations provided. Input the initial guesses for the variables and specify the equations to solve for the unknowns. Ensure that the Solver add-in is enabled in Excel to access these features. This method effectively finds the values of the unknowns based on the given equations.
Baybora
Messages
24
Reaction score
0
How do I make excel to calculate 2 unknown from 2 equations like these

a . x = 5
a. x^2 = 10 for example

How do I do the setup?
 
Physics news on Phys.org
ok found what to do
 

Similar threads

Which software to use to create this graph?
  • · Replies 3 ·
Replies
3
Views
3K
MATLAB How to Plot a 4th Degree Polynomial in MATLAB: Step-by-Step Guide
  • · Replies 7 ·
Replies
7
Views
2K
How to do a finite series in Excel in one row?
  • · Replies 1 ·
Replies
1
Views
2K
Undergrad Error bars in Excel (standard deviation, standard error, percentage)
  • · Replies 4 ·
Replies
4
Views
3K
MATLAB Change the value of a variable at each time step in matlab?
  • · Replies 8 ·
Replies
8
Views
2K
Undergrad Excel projectile trajectory
  • · Replies 6 ·
Replies
6
Views
2K
MATLAB Using Excel Sheet Values as Variables in MATLAB: How Can I Solve for X?
  • · Replies 6 ·
Replies
6
Views
3K
Mathematica How to check a particular solution of System of Linear ODEs?
  • · Replies 1 ·
Replies
1
Views
3K
Undergrad Could anyone give me a step by step guide to using VASP for DFT calculations?
  • · Replies 3 ·
Replies
3
Views
518
Mathematica Mathematica : NDSolve on 2-D steady state heat eqn
  • · Replies 1 ·
Replies
1
Views
2K