Formula question - cell value to make a formula true?

**jabadeer** · 07-19-2011, 10:22 AM

Say i have 3 cells. 2 cells have a number in them and the 3rd cell is between the other two cells. the 3rd cell is empty. I need to have a formula in the 3rd cell that says, the first cell times THIS cell = the 2nd cell. so i need excel to tell me what # i need to make 1*3=2 true.
Thanks for any help!!!

**alansidman** · 07-19-2011, 11:09 AM

Use the Goal Seek feature/function.

See here

http://www.dummies.com/how-to/conten...k-feature.html

**jabadeer** · 07-19-2011, 11:17 AM

Ok, it works great. Now how do i apply this to multiple cells as a formula? do i have to go through this process for every single cell??

**JBeaucaire** · 07-19-2011, 12:07 PM

That's actually a division problem.

With a number in A1 and another number in C1, put this formula in B1:

=C1/A1

Now just copy that cell downward for the next row...