equation in two side by excel

[Mohammad abdelhadi]

dear all,

please find attached file ,

how to solve this equation in excel


Regards,,,,

 

[Hui]

Mohammed

Firstly, Welcome to the Chandoo.org forums

I solved it suing Goal Seek, whuich is probably not the best tool, but it works



Enter the values into the cells B2:C7

Select B2:C7
Goto Formulas, Create From Selection
Tick the Left Column only, Apply

Put a value of 1 into C7

C10: =1/SQRT(x)
C11: =-2*LN((2.51/(Re*SQRT(x)))+(K/D)*0.269)

C13: =C10-C11

Select C13
Goto, Data, What-If Analysis, Goal Seek


Ok

I'm not sure if that is a good value of g or not?

or see attached file:

 

[Hui]

Once the above is setup you may be better to use Solver to solve this
Goto Data, What-If Analysis, Solver

It has much better techniques for looking for a solution.