## Goal Seek or Solver to Solve for two Unknows?

## Goal Seek or Solver to Solve for two Unknows?

(OP)

Hi,

I am trying to figure out if Goal Seek or Solver would be the most appropriate to find two values (Qd for LRB & Qd for NR) that when they are multiplied by a desired value (8 and 24,respectively) would give me another desired value (665.1). Please see attach excel spreadsheet for what I am trying to do.

(8)(Qd for LRB) + (24)(Qd for NR) = 665.1

Really appreciate your help in your guidance on how to accomplish this.

Thanks

I am trying to figure out if Goal Seek or Solver would be the most appropriate to find two values (Qd for LRB & Qd for NR) that when they are multiplied by a desired value (8 and 24,respectively) would give me another desired value (665.1). Please see attach excel spreadsheet for what I am trying to do.

(8)(Qd for LRB) + (24)(Qd for NR) = 665.1

Really appreciate your help in your guidance on how to accomplish this.

Thanks

## RE: Goal Seek or Solver to Solve for two Unknows?

Or you need to explain your requirements in a bit more depth.

## RE: Goal Seek or Solver to Solve for two Unknows?

Doug Jenkins

Interactive Design Services

http://newtonexcelbach.wordpress.com/

## RE: Goal Seek or Solver to Solve for two Unknows?

Qd for NR = (665.1 - 8(Qd for LRB))/24

This result in a line with Qd for NR ranging from 0 to 27.7125 and Qd for LRB ranging from 83.1375 to 0 (if we're only looking at the cases where both Qd's aren't negative).