How do I create a formula for this equation
 

This is what I need. My husband works for an oil company and they have a lot
of paperwork come the first of the month. I need a formula so we can do his
paperwork on the computer. I have the form they use set up in Excel already.
I am using the cells on the sheet I have created. This formula I want to
enter into cell B9. I need B10 times B11 equals x (lets say x so maybe you
might understand what I am talking about). Then squareroot of x times .625.
The .625 will change per chart but I can change that myself. Can you please
help. If this makes any sense at all.

How do I create a formula for this equation
 

On Jul 9, 4:00*pm, sc wrote:
This formula I want to
enter into cell B9. *I need B10 times B11 equals x (lets say x so maybe you
might understand what I am talking about). *Then squareroot of x times ..625. *
The .625 will change per chart but I can change that myself.

=0.625 * SQRT(B10 * B11)

If you put 0.625 into some cell, say A1, you can use the following
formula and simply change A1 when 0.625 changes:

=A1 * SQRT(B10 * B11)

How do I create a formula for this equation
 

=(B10*B11)^(1/2)*0.625

Or if .625 is a variable in C1.............

=(B10*B11)^(1/2)*C1


Gord Dibben MS Excel MVP

On Wed, 9 Jul 2008 16:00:02 -0700, sc wrote:

This is what I need. My husband works for an oil company and they have a lot
of paperwork come the first of the month. I need a formula so we can do his
paperwork on the computer. I have the form they use set up in Excel already.
I am using the cells on the sheet I have created. This formula I want to
enter into cell B9. I need B10 times B11 equals x (lets say x so maybe you
might understand what I am talking about). Then squareroot of x times .625.
The .625 will change per chart but I can change that myself. Can you please
help. If this makes any sense at all.