How do I create a formula for this equation

S

sc

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.
 
J

joeu2004

This formula I want to
enter into cell B9.  I need B10 times B11 equals x (lets say x so maybeyou
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)
 
G

Gord Dibben

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

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

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top